Forms...

[Jason.A.Oliver]

Hi everyone,
Quick question - In the interest of organization I'm using a tab
control to break up an extremely large form I have into several pages.
I had the form set up first before I started doing this so I had all of
the controls already in place when I added the tab control - thus I had
to cut & paste the controls onto the tabs.

I was almost finished when I ran into the error message "Microsoft
Access can't create any more controls on this form or report".

It tells me to rename the form, but that didn't appear to do anything.
I know I CAN fit more controls on there because I had about another 30
that were on it before, and I can't even add individual controls
without getting that message.

Any suggestions?

Thanks!
Jason

[Larry Linson]

There is a number (a rather large number, 700+, as I recall), of Controls
that can _ever_ be added to a Form, even if some of those are later deleted.
The fix to your problem would be to copy and paste all the Controls on that
Form into a new Form, and provided you do not currently have more than the
limit, you will be "back in business." If you'll visit
http://www.mztools.com and download their free software tools, you can copy
the Control and its event code with just one action.

Larry Linson
Microsoft Access MVP
<Ja************@gmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...

Hi everyone,
Quick question - In the interest of organization I'm using a tab
control to break up an extremely large form I have into several pages.
I had the form set up first before I started doing this so I had all of
the controls already in place when I added the tab control - thus I had
to cut & paste the controls onto the tabs.

I was almost finished when I ran into the error message "Microsoft
Access can't create any more controls on this form or report".

It tells me to rename the form, but that didn't appear to do anything.
I know I CAN fit more controls on there because I had about another 30
that were on it before, and I can't even add individual controls
without getting that message.

Any suggestions?

Thanks!
Jason