Highlighting data in textbox after focus

[MikeAngelastro]

Hi,

Using code in Access 97, how do you make sure that all the data in a textbox is highlighted after the textbox receives the focus? The idea is that the user will be able to change what's in the textbox merely by typing. No need to use the mouse.

Thanks.

 

[boblarson]

Try using this in conjunction with the event that sets the focus:

With txtYourTextBoxName
.SetFocus
.SelStart = 0
.SelLength = Nz(Len(txtYourTextBoxName.Value), 0)
End With