Microsoft KB Archive/161011

= ACC97: Disabled Tab Control Page Remains Visible =

Article ID: 161011

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q161011



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When the Enabled property of a page on a tab control is set to False, you can still click the tab and see its controls and the data they contain. However, you cannot change any of the data.



RESOLUTION
There are two methods you can use to hide the data on a disabled tab control page.

Method 1
Set the Visible property of the tab control page to False in the Load event of the form. This makes the tab control page and its tab invisible. Add the following procedure to the Load event of the form, substituting the name of your own tab control:

Private Sub Form_Load If Me!TabCtl0.Pages(1).Enabled = False Then Me!TabCtl0.Pages(1).Visible = False End If  End Sub

Method 2
Set the Visible properties of the controls on the tab control page to False in the Load event of the form. This hides the controls on that page, but allows the tab to remain visible. Add the following procedure to the Load event of the form, substituting the name of your own tab control and page controls:

Private Sub Form_Load If Me!Tabctl0.Pages(1).Enabled = False Then Me!TabCtl0.Pages(1).Controls![HireDate].Visible = False Me!TabCtl0.Pages(1).Controls![ReportsTo].Visible = False End If  End Sub



STATUS
This behavior is by design.



Steps to Reproduce Behavior

 * 1) Open the sample database Northwind.mdb, and create a new blank form based on the Employees table.
 * 2) Add a tab control to the form.
 * 3) On the View menu, click Field List to display a list of available fields for the form.
 * 4) Click the Page 1 tab on the tab control, and drag the EmployeeID, FirstName and LastName fields from the field list to the tab control.
 * 5) Click the Page 2 tab on the tab control, and drag the HireDate and ReportsTo fields from the field list to the tab control.
 * 6) Set the Enabled property of the Page 2 tab to No.
 * 7) Save the form as frmTabCtl and close it.
 * 8) Open the frmTabCtl form in Form view.
 * 9) Click the Page 2 tab. Note that you can see the HireDate and ReportsTo fields, but you cannot change them.

