Setfocus ready for typing?

[Jimmy]

How can I set up a command button that will setfocus on a specific field
that may or may not contain info already and be ready for the user to start
typing. My command button is set right now, that when clicked...
Me.MyFieldName.Setfocus...but if there is data in that field already, the
info is highlighted so if the user begins typing it will overwrite the
current data.

[Arno R]

"Jimmy" <do**@email.meschreef in bericht news:OZ****************@fe06.news.easynews.com...

How can I set up a command button that will setfocus on a specific field
that may or may not contain info already and be ready for the user to start
typing. My command button is set right now, that when clicked...
Me.MyFieldName.Setfocus...but if there is data in that field already, the
info is highlighted so if the user begins typing it will overwrite the
current data.

Look at the Selstart and SelLengthproperties

Arno R

[missinglinq via AccessMonster.com]

This will cause the cursor to move to the end of existing text anytime the
control is entered. I always use this on any control where accidental
overwriting of data would be a problem.

Private Sub MyFieldName_GotFocus()
MyFieldName.SelStart = Len(Me.MyFieldName)
End Sub

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200703/1

[Keith Wilby]

"Jimmy" <do**@email.mewrote in message
news:OZ****************@fe06.news.easynews.com...

How can I set up a command button that will setfocus on a specific field
that may or may not contain info already and be ready for the user to
start typing. My command button is set right now, that when clicked...
Me.MyFieldName.Setfocus...but if there is data in that field already, the
info is highlighted so if the user begins typing it will overwrite the
current data.

Go to the Keyboard tab in Tools/Options and select the "go to end of field"
option.

Keith.
www.keithwilby.com