Maximum Controls on Form

  • Thread starter Thread starter Robert W
  • Start date Start date
R

Robert W

Have built a simple form. Apparently exceeded the 754
controls per form and get the "You can't add any more
controls to this form" message.

Have deleted about 120 controls on the form.

Then copied remaining controls, section by section, to a
NEW form...and am still getting this "You cant..." error
message.

Have physically counted the number of controls and it
appears that the NEW form contains 674 controls...still 80
short of the max.

Anybody/any thoughts how to correct?

Thanks.

Robert
 
A "simple" form with 674+ controls. How could a form with more than half a
thousand controls be simple ??????
Break your form up in multiple forms, reconsider the structure of your
DB.......


knut
 
Thanks for the THOUGHTFUL reply.

-----Original Message-----
A "simple" form with 674+ controls. How could a form with more than half a
thousand controls be simple ??????
Break your form up in multiple forms, reconsider the structure of your
DB.......


knut
"Robert W" <[email protected]> skrev i melding


.
Click to expand...
 
It turns out that when you delete a control, its spot it used it NOT give
back to the available space.

So, in theory, you can have a form with VERY FEW controls actually hit that
error message. In your case, you deleting 100 controls, and should HAVE LOTS
of ability to add new controls. This is not a bug, but certainly a design
issue we have to deal with

The solution is you do encounter this nasty problem is to simply save your
form as a different name (use save-as/export). Delete the existing form.
Now, simply re-name the this form back to the original name. You should then
compact your database.

You will then be able to continue adding more controls.....

So, while the suggeston to reduce the number contols might be good, there is
also work around that all devleopers need to know, since often you can get
that error message, but not even be close, or near that limit of 700+
controls.
 
Back
Top