Can't Create Any More Controls

[Comatose]

I had a form with many controls on it and decided to add a
Tab Control to better view the controls for the user. I
created the Tab Control and then cut and paste my controls
on to each page. Then as I was pasting the rest of the
controls I get an error "Can't create any more controls on
this form or report. If you have deleted controls from
this form or report in the past, you may be able to rename
the form or report and then add more controls to it.".

I tried to rename the form and also tried compacting the
database but I still run into the error. I also tried to
create another Tab Control and paste the rest of the
controls on there but I still got the error. What am I
doing wrong? Is there a better way to move the controls on
to the pages of the Tab Control?

 

[John Vinson]

I had a form with many controls on it and decided to add a
Tab Control to better view the controls for the user. I
created the Tab Control and then cut and paste my controls
on to each page. Then as I was pasting the rest of the
controls I get an error "Can't create any more controls on
this form or report. If you have deleted controls from
this form or report in the past, you may be able to rename
the form or report and then add more controls to it.".

I tried to rename the form and also tried compacting the
database but I still run into the error. I also tried to
create another Tab Control and paste the rest of the
controls on there but I still got the error. What am I
doing wrong? Is there a better way to move the controls on
to the pages of the Tab Control?

You'll probably need to create a brand-new Form, create a tab control
on it, and *then* copy and paste the controls from the old form.
Deleted controls get "remembered", and AFAIK only creating a new form
and transferring the controls will get around this error.

You're limited to some 700 controls on a form (not counting controls
in subforms) - if your form is *that* busy, you need to seriously sit
down and reconsider your design! That's an awful lot to throw at a
user.