TabCtl - too many controls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan B. Densky - 19 Jul 2005 05:05 GMT

I have hit the upper limit of the number of controls on an Access 2000 tab
control. Even though I've deleted a large number of controls on a page of
the tab dialog, it still won't let me add more controls. Apparently Access
ads up the number of controls that you insert, but it doesn't decrease that
number when you delete controls, even if you compact & repair.

Does anybody know how to reset the number of controls on the tabbed dialog
so that I can go about adding back some of the controls without having to
totally rebuild the tabbed dialog?

Alan B. Densky

Reply to this Message

John Vinson - 19 Jul 2005 06:31 GMT

>I have hit the upper limit of the number of controls on an Access 2000 tab
>control. Even though I've deleted a large number of controls on a page of
[quoted text clipped - 7 lines]
>
>Alan B. Densky

Create a new, blank form; put a Tab control on it; and go through the
old form, tab page by tab page, and select all controls, CtrlC to copy
them, select the corresponding page on the new form, and CtrlV to
paste them.

You have to create a new form - but you don't need to rebuild
everything; when you copy the controls over, their relative locations,
properties, labels, etc. will all be preserved.

John W. Vinson[MVP]

Reply to this Message

Alan B. Densky - 19 Jul 2005 13:27 GMT

John,

Thanks for the tip, but pasting controls back to a new tabbed dialog causes
the controls to show up on every tab (page) of the tabbed dialog, that's why
I was looking for another solution. I gave up and rebuilt the forms by
creating a new form, inserting a tabbed dialog, and pasting all of the
controls to new subforms. Then I inserted the subforms into each page of
the tabbed dialog.

Alan

> >I have hit the upper limit of the number of controls on an Access 2000 tab
> >control. Even though I've deleted a large number of controls on a page of
[quoted text clipped - 18 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 19 Jul 2005 18:01 GMT

>John,
>
>Thanks for the tip, but pasting controls back to a new tabbed dialog causes
>the controls to show up on every tab (page) of the tabbed dialog, that's why
>I was looking for another solution.

This is frustrating, but there IS a way around it.

If you just paste the controls onto the form, they end up "in front"
of the tab control, actually on the Form itself - you can drag them
off of the tab page entirely, and they show up on every page.

The trick is to select the *TAB* of the tab page - not the surface of
the page, but the selector tab. The page will darken to indicate that
it has been selected. Ctrl-V will now paste onto the selected page,
not in front of the tab control. Sorry, should have clarified this
little "gotcha"!

John W. Vinson[MVP]

Reply to this Message

John Moore - 24 Jul 2005 15:14 GMT

Alan,

I had the same problem. My solution was to import the form into a new
MDB file, compact that MDB, and then import the form back into the
orgiinal MDB with a slightly different name. When you have determined
that you can add new controls to the newly imported form, you can
erase the original and rename the new form.

TC

Reply to this Message