Can't design on form anymore

[Michael Fong]

I get this message "MS Access can't create anymore
controls on this form or report" when I tried adding new
variables on my form.

Prior the adding these variables to my table which my form
is linked to, I removed some redundant queries.

Any help would be appreciated

 

[Rick B]

Go to help and type "specifications" look atht e specs for forms. It
sounds like you have added more controls over the lifetime of the form than
is allowed.

Rick B

I get this message "MS Access can't create anymore
controls on this form or report" when I tried adding new
variables on my form.

Prior the adding these variables to my table which my form
is linked to, I removed some redundant queries.

Any help would be appreciated

 

[Michael Fong]

Is there any way to allow design changes? Ie. create a new
form and paste the exceeded form material over?

 

[Rick B]

I think you can add sub forms with more items. If you start with a fresh
form and cut and paste, then all those old deleted controls (lifetime
records) should no longer count.

That is just theory from me. Not tested.


Is there any way to allow design changes? Ie. create a new
form and paste the exceeded form material over?

 

[Albert D. Kallal]

it is possible that this form had a LOT of design changes made to it.

You can do the following to re-set this.

Simply highlight the form, and then do a save-as.

Give the form a temp name. Now, delete the original, and then re-name your
form back.

You should be able to add more controls. Note that a form has a max number
of controls around 700.

 

[Rick B]

Awesome suggestions. Much better than creating a new form and trying to
paste everything back. Thanks Albert. I may be using this same advise soon
on a form that I have used for about 4 years.

Rick B


it is possible that this form had a LOT of design changes made to it.

You can do the following to re-set this.

Simply highlight the form, and then do a save-as.

Give the form a temp name. Now, delete the original, and then re-name your
form back.

You should be able to add more controls. Note that a form has a max number
of controls around 700.