This should work in any form of text box. Basically, the text box used for numbers, letters or any other kind of data is all the same, with options set differently (such as the entry mask, length, etc).
HTH,
Hugo
>Hi Hugo,
>
>Is there a quick way to make this work this way for all numeric text boxes in an existing application? And not for non-numeric test boxes...
>
>Joe
>
>>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
"My get up and go must've got up and went"
-Steve Tyler, Aerosmith