OK . . .vakjay . . . here we go . . .
To solve your problem
you need to use some event from the Tab Control to manipulate your textboxes of interest. Lonnie had the right idea in relation to the
Click Event, but I myself have never gotton it to work. An event that always works and tracks Page changes in the Tab Control, is the
Change Event. Any time you select a different page (tab) in the control, the Change Event is triggered. This event will be used to handle your textboxes.
For your textboxes, you'll be controling the
Visible Property of each. This property hides or shows the textbox.
As an example, lets say we have a Tab Control named "TC1" with five pages. And we want to hide the textboxes when the 3rd or 4th tabs are selected. The following code would be placed in the Change Event for the Tab Control to accomplish this:
Dim TB As TabControl
Set TB = Me!TC1
If TB.Value = 2 Or TB.Value = 3 Then
Me!txt1.Visible = False
Me!txt2.Visible = False
Else
Me!txt1.Visible = True
Me!txt2.Visible = True
End If
Note that the values in the code are 2 & 3 instead of 3 & 4. This is because the tabindex for the control is zero based (starts at zero), so 1 has to be subtracted from the actual position.
Events play a major role in any application interface you may design. So get to know them well.
TheAceMan