Micrsoft Access can't create any more controls on this form or report?

[Roballistic]

I have created a form in Microsoft Access 2000, and need to add more cnotrols. It has apparently run out of space, so I'm stuck, unless someone know a way around this? Thanks for any help you can provide...

 

[Blanch]

I would look up Aceess Specifications in HELP. It will outline the limits that you might be hitting.

If you are putting 754 controls on a single form, you should rethink how you intend on using the form.

Jim Hope this helps!

Jim

 

[Roballistic]

I have created a form with a Tab Control to be used as a checklist with many questions that must be answered yes, no or NA. in addition, I have hyperlinks to the web and documents. I do have 754 controls, so my question is how to get around that if possible? Thanks for your prompt responses...
Roballistic

 

[PaulBricker]

I agree that 754 controls on a form would be unusual, but the specifications say that 754 is the lifetime limit for a Form or Report. So if you are adding and deleting controls on a Form or Report, you may very easily hit that limit.

Paul

 

[Blanch]

You can also have up to 7 Subforms - how about breaking up the form into logical areas and then moving some of the controls to a subform.

In theory you could have one parent form with 754 - 7 = (747 controls) + (7 Forms * 754) = 6025 Controls.

This is an untested theory. To handle the aspect of bound controls. I personally would use all unbound forms and controls and use VBA to update, insert and delete data.

Hope this helps!

Jim Hope this helps!

Jim