Highlighting Field Data when Entered

[EddieN1]

I have a datasheet form with one numeric field per row where the operators will accept or update. This is high-volume so I'm trying to make this as fast for the operators as possible. When the operator gets to a row, I would like the field to appear as if the data has had the mouse dragged across it, so that when the operator types a digit, it will replace the previous value. If the operator just hits enter, the value won't be changed. How can I do that? Thanks, Eddie

[June7]

You can have the data selected when the control gets focus, example:

Private Sub tbxDateOut_GotFocus()
Me.tbxDateOut.SelStart = 0
Me.tbxDateOut.SelLength = Len(Nz(Me.tbxDateOut, ""))
End Sub

[Missinglinq]

...When the operator gets to a row, I would like the field to appear as if the data has had the mouse dragged across it...

It sounds as if you want the Control to have the focus as soon as the user moves to a Record; if this is correct, just modify June7's code slightly and place it in the Form_Current event:

Private Sub Form_Current()
  tbxDateOut.SetFocus
  Me.tbxDateOut.SelStart = 0
  Me.tbxDateOut.SelLength = Len(Nz(Me.tbxDateOut, ""))
End Sub

Linq ;0)>

[EddieN1]

This works as long as the form is in Continuous Form view, but not in Datasheet view. Any way I can make this work in Datasheet view? Thanks for your help. Eddie

[Missinglinq]

Don't really know what to tell you; works as it should, for me, in a Form in Datasheet View!

Linq ;0)>