Not able to create any more controls on the form

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

Guest

Hi,

I was trying to add new controls on a form and I get below error message
always.

"Microsoft Access can not create any more controls on the form".

When I get this message always I used to import my old database into new one
and then I was able to add few controls. I always repeat this process
whenever I have to add new controls. But today I wan't able to add any new
controls even when I import my database to the new one. I am not sure why? I
am sure that I didn't exceed the limit on controls.

Can any one please help me with this. I have been trying for long time with
several ways but no luck.

Thanks.
 
If you have been adding and deleting controls, compact the database:
Tools | Database Utilities | Compact/Repair
or in Access 2007:
Office Button | Manage | Compact/Repair

You can have 700-odd controls on a form. Compacting gets rid of controls you
deleted. If there is still a problem after compacting, something else is
wrong.
 
I already tried doing compact and repair. But still it does'nt work. I am not
able to figure out what might went wrong. Untill couple of days back I was
able to add new contorls on a form and all of a sudden I have an issue.

I got to update the database today. Can you suggest me any other way.

Thanks.
 
First thing might be to ask Access how many controls are on the form.

Open it in design view (with no other forms open.)
Then open the Immediate Window (Ctrl+G), and enter:
? Forms(0).Controls.Count

How many does it say you have?

You may like to turn off Name AutoCorrect by unchecking the boxes under:
Tools | Options | General | Name AutoCorrect
In Access 2007, it's:
Office Button | Access Options | Current Database | Name AutoCorrect
Then compact again.
Explanation of why:
http://allenbrowne.com/bug-03.html
 
? Forms(0).Controls.Count shows me 892. I can't believe I exceeded the limit
on the controls. I haven't created this database. I am not sure why this
form has 892 controls without having subforms. What I am supposed to do. I
just have to add two more controls for today. Can you suggest me on this?

Thanks.
 
No: that's too many.

The solution will be to redesign the database so it is normalized, and you
are not trying to do everything in one form.

If you are desparate, you could delete a few labels, and then compact the
database and try again.
 
I thought that the limit was "over the lifetime of the form": in other
words, compacting won't help.

Try creating a new form, and copying-and-pasting from the old form.
 
I deleted some of the labels and added the new control as this update was an
high protity update. But eventually I will redesign the database by
normalizing the tables. This might be a challenging work for me. How could
any one create database without any primary key or having normalization on
the tables.

I appreciate all your help.

Thanks.
 
Back
Top