system crashing after i delete a few labels on my form.

[chubbypama]

I have a form with lots of controls on it.
i need to add one more button but it's saying that i have too many controls.
so i've tried to delete 3 or 4 labels...
But when i try to run the form, ms access crashes and attempts to compact and
repair the database. That unfortunately, doesn't fix the problem.
do you have any suggestions?
thanks.

 

[Linq Adams via AccessMonster.com]

Not really sure about the crashing, but deleting labels and then adding new
ones won't solve the problem. The control count, with a limit of 754, is for
the lifetime of the form. In other words, if you have 10 controls on a form,
delete 5 of them, the total remains 10; deleting them doesn't remove them
from the count!

I'd create a new, blank database and import everything (tables, forms,
reports, etc)
into it. I believe this will reset the control count the the actual number of
controls currently on the form.

BTW, how many controls are currently on the form?

 

[chubbypama via AccessMonster.com]

Hi there. Thanks for the response.
I've tried creating a new blank database and importing everything... but now
when i try to run the form, it crashes right away!
Yikes. ALso, is there any way to take a count of the controls besides
manually?

 

[Linq Adams via AccessMonster.com]

is there any way to take a count of the controls besides manually?

No way that I'm aware of. You could goto

Tools - Analyze - Documentor

and use it to list out the controls, to make counting easier, keeping in mind
that deleted controls won't appear here (I beieve) but will still be included
in the lifetime count.

Importing into the new database should have reset the count to the number of
controls currently on the form, so I'd lean towards the crash coming from
some type of corruption. This happening when you tried to delete controls/add
new controls may have simply been coincidental, and the problem not really
related to this action.

Maybe someone else will be able to think of something.

 

[Klaus-Dieter Gundermann]

The control count, with a limit of 754, is for the lifetime of the form.

Do you have any source for this information ??

 

[Linq Adams via AccessMonster.com]

Do you have any source for this information ??

For the Specifications/Limits in Access?

http://bytes.com/topic/access/insights/603897-microsoft-access-specifications