text box - tabbing issue

  • Thread starter Thread starter Zoe
  • Start date Start date
Z

Zoe

I have a bound text box on my form.
I want the information to display but I do not want the user to be able to
change it.
Enabled = No
Locked = Yes
Tab Stop = No
These settings seem to do want I want except when I tab through the other
text boxes on my form. If I tab past the locked text box, the information in
the text box disappears.
I know I am missing something, but I cannot figure out how to prevent this.
Any assistance is appreciated!
 
Zoe said:
I have a bound text box on my form.
I want the information to display but I do not want the user to be able to
change it.
Enabled = No
Locked = Yes
Tab Stop = No
These settings seem to do want I want except when I tab through the other
text boxes on my form. If I tab past the locked text box, the information
in
the text box disappears.
I know I am missing something, but I cannot figure out how to prevent
this.
Any assistance is appreciated!
Click to expand...

I'm guessing that your text box would be the last control in the tab order,
and your form's Cycle property is set to All Records, and AllowAdditions is
Yes/True. So when you tab past this control, your form goes to a new blank
record.

If this is the case, you can correct it by either setting the form's Cycle
property to "Current Record", or by setting the form's AllowAdditions
property to No (so there will be no blank record to fill in.
 
Zoe,
Do you mean that the text control itself actually disappears, or the
text control appears as "greyed out?"

If Greyed out, try...
Enabled = Yes
Locked = Yes
Tab Stop = No
which will accomplish the same thing. (Skip field in tabbing, and no data
change allowed)

If disappearing, check that you may have some code like...
YourControlName.Visible = False
triggering somewhere down the line from the contol involved. Like an
OnEnter event maybe?
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top