Too many controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am building a tab form and it is quite large. I have a few more things to
do, but am now getting the message "too many controls on form". Any way
around this?
 
Hi, Patty.
I am building a tab form and it is quite large. I have a few more things to
do, but am now getting the message "too many controls on form".
Click to expand...

The maximum number of controls allowed on a form is 754. Each time a
control is deleted, the counter is not reset, so even if you don't currently
have this many controls on your form, this form has reached the end of its
lifecycle.
Any way
around this?
Click to expand...

If you don't actually have 754 controls on your form, then you could start
fresh with the current number of controls. There are two ways to do this.
First, make a backup of your database file, just in case something goes
wrong.

1.) Create a new form and copy all of the controls from the overloaded form
onto it. Copy the code from the overloaded form and paste it into the
module of the new form. Delete the overloaded form. Rename the new form
with the same name as the form you just deleted. Compile the code and
compact/repair the database.

2.) Create a new database file and import this overloaded form into it.
Delete the overloaded form from the original database. Compact/repair the
original database. Import the overloaded form from the new database into
the original database. Compile the code.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Camero's advice is likey a solution.

And, you can actually re-set the counter in the following manor..and no
cut/paste is needed:

You can actually just highlight the form (don't even have to open it in
design mode).

You then go file-save as

Just give the form a different name. Now, delete the original one, and
rename the one you just coped. You do a compact..and you are back in
business, and the "counter" is re-set. This approach is safer as no cut and
paste occurs (and things like forgetting to copy code etc is eliminated).
 
Back
Top