Why I am not able to add new controls on a form

[taniadimitri]

Hi,

I was trying to add new controls on a form and I am getting a message saying that "Access can not create any more controls on this form. Please rename the form to add more controls". I get this message always and then I was able to add new controls by importing the form to a new database and then renaming it.

But today I am not able to add any new controls even if I import old database into new one. I am not sure why. I am I didn't exceed the limit of controls on a form. Does anyone have suggestions.

thanks,

 

[boblarson]

Just so you know, there is a limit of about 754 controls that can be created (A2K version - others might be different) over the lifetime of the form or report.

You should compact and repair your database BEFORE importing those forms into a new database. It may be, if you don't, the counts come over in the import. I'd compact and repair first, then create a new mdb file (don't try to bring it over in one you already tried in), and see how that works.

 

[taniadimitri]

How do I find the count of controls in a form?

I tried giving this in immediate window but it didn't work.

?Forms("Formname").Controls

Is there any other to find the number of controls?

 

[boblarson]

It's not the number on the form, the count also includes those you've added and then deleted. I don't know of any way to find what the current count of controls added over the lifetime of a form is.

 

[taniadimitri]

I did repair my database and then imported the form into a new datasbase and then back again. But it still it doesn't work.

 

[boblarson]

You shouldn't be trying to bring it back again. You should just import EVERYTHING into a new one and scrap the old.

 

[RuralGuy]

I don't know of any way to find what the current count of controls added over the lifetime of a form is.

I could be wrong here but if you add another control (assuming you can) I believe Access will default the name to ControlNNN where NNN is the actual amount of controls added over the lifetime of the form. Of course this does not help if you can't add any more controls.

 

[boblarson]

I could be wrong here

Darn it, you're not!

Of course this does not help if you can't add any more controls.

This is true