A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

text box - tabbing issue



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2008, 10:00 PM posted to microsoft.public.access.forms
zoe
external usenet poster
 
Posts: 97
Default text box - tabbing issue

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!




  #2  
Old September 15th, 2008, 10:10 PM posted to microsoft.public.access.forms
AAccess
external usenet poster
 
Posts: 10
Default text box - tabbing issue

Try to switch Enabled to Yes (leave Locked and Tab Stop = No).

"Zoe" wrote:

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!




  #3  
Old September 15th, 2008, 10:10 PM posted to microsoft.public.access.forms
Dirk Goldgar
external usenet poster
 
Posts: 2,529
Default text box - tabbing issue

"Zoe" wrote in message
...
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!


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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

  #4  
Old September 15th, 2008, 10:15 PM posted to microsoft.public.access.forms
zoe
external usenet poster
 
Posts: 97
Default text box - tabbing issue

I still have the issue.
My settings a
Enabled = Yes
Locked = Yes
Tab Stop = No

Arghh!


"AAccess" wrote:

Try to switch Enabled to Yes (leave Locked and Tab Stop = No).

"Zoe" wrote:

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!




  #5  
Old September 15th, 2008, 10:22 PM posted to microsoft.public.access.forms
zoe
external usenet poster
 
Posts: 97
Default text box - tabbing issue

I changed Allow Additions to No and it works perfectly.
Thanks so much!

"Dirk Goldgar" wrote:

"Zoe" wrote in message
...
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!


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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


  #6  
Old September 15th, 2008, 10:33 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default text box - tabbing issue

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."


"Zoe" wrote in message
...
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!






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.