How many controls on a form? 256. Controls on subforms count?

[gusbrunston]

Hi, and thanks for your help.

I've searched the books and the threads...

I know (or read) that there is a limit of 256 controls on a form. What I don't know is if that limit includes the controls on a subform.

I have a tab control as a main data viewing form, and I keep adding subforms under the tabs. It is a convenient and quick way for the user to move around among related but different classifications of data.

If the limit of 256 controls does NOT include subforms, then it looks like I will be O.K. If the limit is 256 controls regardless of whether they are on the main form or on subforms, then I'll soon reach the limit.

Your help is appreciated, and I wish you a happy holiday season from the cool and colorful state. Gus Brunston An old PICKer, using Access2000
gustrel@aol.com

 

[rhicks]

The limit is 754 for each form. Each time a control is added to the form the control count increments by 1. If you delete any controls from the form this number does not reduce .... even if you compact the db. So when the accumulated total reaches 754 you will receive an error.

The only way to recover to the actual count of controls on the form is to open a new empty form, copy and paste all of the controls to the new form (be sure to get any code in the form module).

HTH
RDH Ricky Hicks

 

[gusbrunston]

Thanks, Ricky!

Just exactly what I need to know. Gus Brunston An old PICKer, using Access2000
padregus@attbi.com

 

[rhicks]

You are welcome .....

Happy Holidays,
RDH Ricky Hicks
Birmimgham, Alabama