Disable selection of Text Box

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Greetings all...My issues today is that I have a Text Box on a form that is
formatted to display the value of a field; "=[FName] & " " & [LName]". Now
although I can't edit the information in the Text Box, I can select it. Is
there a way to prevent it from being selected. You may ask what would it
matter if it’s selected if you can't edit it. Brings me to part two of my
inquiry. Is there a way to have the cursor start on a particular field when
the form is opened. Something like on open go to field LName so that an
entry can be made if need be. Thanks in advance for any and all suggestion.
 
I promise I tried that already, but now I feel dumb for asking and what I
thought should work WORKED. But you didn't comment on what I should do to
have the cursor move to the first entry field or a field of my choosing
altogether.
--
Work is sometimes hard....but someone has to do it.


Ofer Cohen said:
Change the Enabled property of the Text Box to No

--
Good Luck
BS"D


Pierre said:
Greetings all...My issues today is that I have a Text Box on a form that is
formatted to display the value of a field; "=[FName] & " " & [LName]". Now
although I can't edit the information in the Text Box, I can select it. Is
there a way to prevent it from being selected. You may ask what would it
matter if it’s selected if you can't edit it. Brings me to part two of my
inquiry. Is there a way to have the cursor start on a particular field when
the form is opened. Something like on open go to field LName so that an
entry can be made if need be. Thanks in advance for any and all suggestion.
Click to expand...
Click to expand...
 
Sorry forgot this part.
There are a couple of ways
1. Set the TAB order of the fields in the form, and specify the first field
Open the form in design view, and select from the menu "View" -> Tab Order

2. On the form OnLoad event of the form you can use the SetFocus to set the
focus to any field

Me.[TextBoxName].SetFocus

--
Good Luck
BS"D


Pierre said:
I promise I tried that already, but now I feel dumb for asking and what I
thought should work WORKED. But you didn't comment on what I should do to
have the cursor move to the first entry field or a field of my choosing
altogether.
--
Work is sometimes hard....but someone has to do it.


Ofer Cohen said:
Change the Enabled property of the Text Box to No

--
Good Luck
BS"D


Pierre said:
Greetings all...My issues today is that I have a Text Box on a form that is
formatted to display the value of a field; "=[FName] & " " & [LName]". Now
although I can't edit the information in the Text Box, I can select it. Is
there a way to prevent it from being selected. You may ask what would it
matter if it’s selected if you can't edit it. Brings me to part two of my
inquiry. Is there a way to have the cursor start on a particular field when
the form is opened. Something like on open go to field LName so that an
entry can be made if need be. Thanks in advance for any and all suggestion.
Click to expand...
Click to expand...
Click to expand...
 
thank you.. information was vary useful
--
Work is sometimes hard....but someone has to do it.


Ofer Cohen said:
Sorry forgot this part.
There are a couple of ways
1. Set the TAB order of the fields in the form, and specify the first field
Open the form in design view, and select from the menu "View" -> Tab Order

2. On the form OnLoad event of the form you can use the SetFocus to set the
focus to any field

Me.[TextBoxName].SetFocus

--
Good Luck
BS"D


Pierre said:
I promise I tried that already, but now I feel dumb for asking and what I
thought should work WORKED. But you didn't comment on what I should do to
have the cursor move to the first entry field or a field of my choosing
altogether.
--
Work is sometimes hard....but someone has to do it.


Ofer Cohen said:
Change the Enabled property of the Text Box to No

--
Good Luck
BS"D


:

Greetings all...My issues today is that I have a Text Box on a form that is
formatted to display the value of a field; "=[FName] & " " & [LName]". Now
although I can't edit the information in the Text Box, I can select it. Is
there a way to prevent it from being selected. You may ask what would it
matter if it’s selected if you can't edit it. Brings me to part two of my
inquiry. Is there a way to have the cursor start on a particular field when
the form is opened. Something like on open go to field LName so that an
entry can be made if need be. Thanks in advance for any and all suggestion.
Click to expand...
Click to expand...
Click to expand...
 
The code that you gave me worked. But I have a small issue making it work
with another field and new record.

More info on what my intent is. I have a classification banner above my
form and below it. The Classification box is the same for the exception of
the fact that I would only use one as an entry field. -I have not disable
the lower text field yet - On top of that, the banner is also on 2 other tab
pages. So of course the field name [Classification] changes to
[text171],[text172]......

I have used the same code and placed it in the On Enter property field.
This only updates on the other tabs [field(s)] once I click in the field.
And when I change records, the backcolor does not change or display the color
with the corresponding text already entered. If the multiple text fields
does not allow this to work as I intend, is it possible to use a Macro to
accomplish this. Any suggestion would be helpful.
--
Work is sometimes hard....but someone has to do it.


Ofer Cohen said:
Sorry forgot this part.
There are a couple of ways
1. Set the TAB order of the fields in the form, and specify the first field
Open the form in design view, and select from the menu "View" -> Tab Order

2. On the form OnLoad event of the form you can use the SetFocus to set the
focus to any field

Me.[TextBoxName].SetFocus

--
Good Luck
BS"D


Pierre said:
I promise I tried that already, but now I feel dumb for asking and what I
thought should work WORKED. But you didn't comment on what I should do to
have the cursor move to the first entry field or a field of my choosing
altogether.
--
Work is sometimes hard....but someone has to do it.


Ofer Cohen said:
Change the Enabled property of the Text Box to No

--
Good Luck
BS"D


:

Greetings all...My issues today is that I have a Text Box on a form that is
formatted to display the value of a field; "=[FName] & " " & [LName]". Now
although I can't edit the information in the Text Box, I can select it. Is
there a way to prevent it from being selected. You may ask what would it
matter if it’s selected if you can't edit it. Brings me to part two of my
inquiry. Is there a way to have the cursor start on a particular field when
the form is opened. Something like on open go to field LName so that an
entry can be made if need be. Thanks in advance for any and all suggestion.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top