No More Controls

[Guest]

Hello,
I'm updating an older form that has many controls with most of them
corresponding to a column in a table. I've split the single form and placed
its sections on 3 newly created tabs.

PROBLEM: The entire tab control at some point ended up in the Page Header
section. I cut it out and pasted it into the Detail section then I got this
error message:

"Microsoft Office Access 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 renamed the form and I still can't add another page to the tab control.

Why is this happening? and How do I fix it?
Thank you

 

[Ken Snell \(MVP\)]

Lifetime limit is 754 controls created on a form -- even if you've deleted
some.

Try compacting the file. This may not solve the problem, though.

You can open a new database, import the form into that database, delete the
form from the first database, then import the form from the second database
back into the first database.

If that doesn't work, then you'll need to start with a new form and build
it again.

 

[John W. Vinson]

I'm updating an older form that has many controls with most of them
corresponding to a column in a table. I've split the single form and placed
its sections on 3 newly created tabs.

If you have so many fields in your table that you need three tab pages for
them... *your table design is WRONG*.

30 fields in a table is very wide. 60 is the most I've ever had to use (except
for one data-warehousing application).

I suspect that a flawed table design is at the root of your problem!

John W. Vinson [MVP]