Controls on Form Limit

A

Ayo

Is there a limit to the number of controls that can be on a form? I have have
a big problem with a form I just finished designing and I am sure it is
because of the amount of controls I have on the form. Any ideas.
 
D

Douglas J. Steele

There is a limit of 754 controls over the life time of the form. Note that
that means if you started with some controls and then deleted them, those
are still part of the count. There's no way to reset the count. What you can
do, however, is copy all of the controls on the form onto a new form (and
copy the code from the form's module).
 
J

John W. Vinson

Is there a limit to the number of controls that can be on a form? I have have
a big problem with a form I just finished designing and I am sure it is
because of the amount of controls I have on the form. Any ideas.
Click to expand...

From the Help (search for "Specifications"):

Number of controls and sections you can add over the lifetime of the form or
report 754

You may be able to recover some of these by Compacting the database; if not,
you can create a new, empty form, select all the controls in the old form, and
copy and paste them onto the new one.
 
S

shenrong

??
John W. Vinson said:
From the Help (search for "Specifications"):

Number of controls and sections you can add over the lifetime of the form or
report 754

You may be able to recover some of these by Compacting the database; if not,
you can create a new, empty form, select all the controls in the old form, and
copy and paste them onto the new one.
Click to expand...
Click to expand...
 
Top