Locking a tab in a tabbed form

[focosi]

It seems to me that the .Locked (or .readOnly) data property can be set only for single controls, but not for whole tabs in tabbed forms. On the contrary the .Enabled property works for whole tabs.
Any turnaround to this limitation ??
Thx

[RuralGuy]

You just don't like the dimming of the controls on the page of the TabControl?

[focosi]

the point is not just aesthetic, but rather
1) dimmed (disabled) controls are too clear to be printed and read satisfactorily
2) I need users to be able to get focus and copy content of locked controls, which can't be done if the controls are disabled
Any hint to lock a tab ?

[RuralGuy]

In that case you are probably stuck with a For Each Control...Loop

[focosi]

good point.
Could you please drive me through the VBA syntax for the "For Each Control in tab" statement ?
Thanks

[RuralGuy]

Something like:

   Dim ctl As Control
   For Each ctl In Me.Controls
      If ctl.ControlType <> acLabel Then
         ctl.Locked = True
      End If
   Next ctl

[focosi]

ok, but can I use this ??
For Each ctl In MyTabName.Controls

[RuralGuy]

The TabControl is not a real control which is why *every* control on all of the pages needs to have an unique name. I would probably put something useful in the tag property of the controls I wanted locked and check for that value in the loop.