Two many controls

[Oded Kovach]

Hello there

I have form that i've place on it two many controls

As a result of that i can't use it anymore. when i open it for design, view
or even delete it the access is going out.

what can i do

any help would be useful

 

[Graham R Seach]

Oded,

The problem is probably more a matter of a large number of control changes
being made to the form. You see, Access 2003 will only allow you to add 754
controls to a form over the lifetime of the form. I don't recall the limit
for previous versions. For example, if you were to add a textbox to an
Access 2003 form, then delete it, then repeat the same process 754 times,
Access would complain that you have too many controls on the form.

To get around this problem, create a new database, and import the offending
form into it. If you want, you can then delete the form from the original
database, compact, then re-import the form.

Mind you, if you have a truckload of controls on a form, I'd be looking at
your design. I've never seen a user interface where large numbers of
controls are actually necssary. No user could take in that much information
at one time anyway, so the rule is, KISS.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[John Vinson]

Whell John

I can't do nither of the things you said

any touch of it (enter as design, open, export and even delete) drop me out
of access

Ow!

You can't even create a new, empty database and import it?

If not... and if Compacting the database doesn't help...

Get out your backup disk.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps