Access - Bound Textbox Select existing info when GotFocus or DoubleClick
Posted on 2014-01-26
Have a bound form. Bound form has Bound textboxes. If I'm going back to a prior input box I want the info in that bound textbox "selected" so that the user doesn't add info to it but overrides it.....
The bound boxes are formatted "Currency" problem is, as you probably know, if I've input 20 for $20.00 then it only sees the Len as "2"
My code is ....
Private Sub tAmt_GotFocus()
Me.tAmt.SelStart = 0
Me.tAmt.SelLength = Len(Me.tAmt)
So it only "selects" 2 characters in my bound textbox...