Prevent Focus on Text Box

[Guest]

I have a form (Master) - that has a subform (Area) on 1 of 7 tab controls.
The subform also has a subform (Area list) that I will call the "subsubform".
The subsubform is set to Continuous Form, Snapshot (the Allow
Edits/Delitions/Additions/Data Entry are set to No), with All Records locked.

There are 3 text boxes on the subsubform - Area Type, Current ?, and Date
Established. I have all 3 set to "Tab Stop = No", "Back Style = Transparent",
"Border Style = Transparent", and "Locked = Yes".

I want these to not be able to "get the focus". What happens now is that
when I click the tab control to see the subform Area, the first field on the
first row of the subsubform (Type) is "highlighted" with the Back Style Not
Transparent (that is - the background color of the subsubform is not showing
in the field - the background is white). And, the cursor is blinking in the
field. I want these text boxes to be "static" - not able to get the focus,
with background transparent.

What am I missing?

Thanks - John D

 

[Guest]

Remove the controls from the Tab Order of the form. Tab Orders are listed by
form sections, header, detail, and footer.

 

[fredg]

I have a form (Master) - that has a subform (Area) on 1 of 7 tab controls.
The subform also has a subform (Area list) that I will call the "subsubform".
The subsubform is set to Continuous Form, Snapshot (the Allow
Edits/Delitions/Additions/Data Entry are set to No), with All Records locked.

There are 3 text boxes on the subsubform - Area Type, Current ?, and Date
Established. I have all 3 set to "Tab Stop = No", "Back Style = Transparent",
"Border Style = Transparent", and "Locked = Yes".

I want these to not be able to "get the focus". What happens now is that
when I click the tab control to see the subform Area, the first field on the
first row of the subsubform (Type) is "highlighted" with the Back Style Not
Transparent (that is - the background color of the subsubform is not showing
in the field - the background is white). And, the cursor is blinking in the
field. I want these text boxes to be "static" - not able to get the focus,
with background transparent.

What am I missing?

Thanks - John D

You can set the control's Enabled to No AND Locked to Yes.
The Color will not change, the user will not be able to enter the
control, the control will not receive focus.

 

[Guest]

Thanks Fred - I need to read up on "Enabled" because I had the impression it
was used only if you applied a conditional format to the control (like - if
negative:red). But all I had to do was set Enabled to No - and it worked!

Klatuu - I couldn't figure out how to remove the controls from the tab
order. Under View/Tab Order in Design View, I saw no way to remove controls
from the list.

Thanks guys

John D

 

[fredg]

Thanks Fred - I need to read up on "Enabled" because I had the impression it
was used only if you applied a conditional format to the control (like - if
negative:red). But all I had to do was set Enabled to No - and it worked!

Klatuu - I couldn't figure out how to remove the controls from the tab
order. Under View/Tab Order in Design View, I saw no way to remove controls
from the list.

Thanks guys

John D

There is no need to remove the control from the list if you don't want
the focus to stop there when tabbing. Just set that control's Tab Stop
property to No. It on the control's property sheet's Other tab.