>Does this work for ALL textboxes, or can you (as a developer) specify which ones you want to act which way?
>
>Joe
>
>>>Hi all,
>>>
>>>I posted this message on the VB and Office/Access forum but there was no one there to respond.
>>>
>>>How do I specify in the Access 97 form designer for a text box that I DON'T want to select all the text in the field when entering the text box. I don't see any properties for SelectOnEntry etc. and there don't seem to be any options for this.
>>>
>>>Thanks for your help!
>>>
>>>-JT
>>
>>Try this,
>>
>>go to the Tools menu, choose options.
>>
>>Go to the Keyboard tab and select what you want Access to do on the upper right-hand side (Behavior entering field box).
>>
>>It should be on "Select entire field" at the moment, just choose one of the other options and that's it!
>>
>>Hugo

This method will affect ALL the text boxes, datasheet vies, queries, you name it. What you can do is use the OnEnter event on the form and set the selstart and sellength fields. To select the whole field by code, use this snippet:

me.text1.selstart = 1
me.text1.sellength = 0

This will effectively de-select the entire field. To select the entire field by code, use this snippet:

me.text1.selstart=1
me.text1.sellength = len(me.text1.text)

HTH

Hugo