Read Only Tab

S

Secret Squirrel

Is it possible to make a tab on a tab control read only? Just looking to make
1 of the tabs read only.
 
J

John W. Vinson

Is it possible to make a tab on a tab control read only? Just looking to make
1 of the tabs read only.

No, but you can set the Enabled property of each control on the tab to No, and
the Locked property to Yes to achieve the same effect.
 
S

Secret Squirrel

Hi John,

Is there an easy way to lock all the controls on a specific tab without
having to spell every control out in VBA?
 
J

John W. Vinson

Hi John,

Is there an easy way to lock all the controls on a specific tab without
having to spell every control out in VBA?

hmmmm... not sure... you might be able to loop through the form's Controls
collection and check each one's Parent property. Let's see...

Yep. From the immediate window:

?forms!frmComplaint!cboStatus.parent.name
pgDispatch
?forms!frmComplaint!txtNotes.parent.name
pgNotes
 
Top