Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    controls on form (Access 2000)

    I would like to know if there is a limit on the number of controls that I can place on a single form.

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: controls on form (Access 2000)

    Yes, there is: you can create a maximum of 754 controls on a form or report during its lifetime. So once you have created 754 controls, it doesn't help to delete a few of them; you won't be able to create new ones any more. In that case, it is better to create a new form and copy the controls you need from the old form to the new one.

    A way to get around the limit is to use subforms.

    (Note: you can find the limit in the online help if you type Specifications in the Answer Wizard)

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: controls on form (Access 2000)

    In A97 and A2000 it's 754 controls to a form or report.
    You can see these limits in the help under Specifications - Microsoft Access.

    Pat

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: controls on form (Access 2000)

    Just to add to what Hans and Pat have told you, controls include any graphics, lines, boxes, etc., as well as data controls. Access keeps track of the controls you have added to the form or report without considering any you may have removed. There are also limits to the physical size of the form or report. I've run into the number of controls limit when creating a form with lines to simulate a printed form and had to use subforms to solve the problem.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •