TabCtl - too many controls

[Alan B. Densky]

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

 

[John Vinson]

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

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]

 

[Alan B. Densky]

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

 

[John Vinson]

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]