Taking your idea a step further, I found asimpler ...

2007-05-25T12:47:25.007+04:00

Taking your idea a step further, I found a
simpler way to avoid the problem. Simply make all controls on all pages of
the tab control invisible, then run code from the tab control's On Change
event to make only the controls on the current page visible (also need to
run it from the form On Open or On Current event so that the controls are
initially displayed).

Below is the code I came up with (for a tab control named "tabMain"). Seems
to resolve the problem, and allows you to keep all your controls on the tab
control, instead of moving them off.

Dim ctl As Control
Dim pg As Page
Dim blnVisible As Boolean

For Each pg In Me.tabMain.Pages
blnVisible = (pg.PageIndex = Me.tabMain)
For Each ctl In pg.Controls
ctl.Visible = blnVisible
Next
Next

Comments on Alex & Access: ActiveX controls on Tab control page

Taking your idea a step further, I found asimpler ...