G
Guest
(I already asked this but can't find my question. Sorry.)
I have set the focus to a text box OnCurrent of my form. I have used the
following to have the cursor start at the end of the text:
Private Sub Call_Notes_Enter()
With Me.Call_Notes
.SetFocus
.SelLength = 1
.SelStart = Len(.Text)
End With
End Sub
This works except when the user tabs from one record to the next, then all
the text is highlighted making it very easy to accidentally delete or alter
that text. It does work if the user tabs to the field within the form or if
using the navigation arrows to go from one record to another, but not if they
tab to the end of one record, continue tabbing into the next record, which is
what they will do most often.
Thanks for your help,
Kristine
I have set the focus to a text box OnCurrent of my form. I have used the
following to have the cursor start at the end of the text:
Private Sub Call_Notes_Enter()
With Me.Call_Notes
.SetFocus
.SelLength = 1
.SelStart = Len(.Text)
End With
End Sub
This works except when the user tabs from one record to the next, then all
the text is highlighted making it very easy to accidentally delete or alter
that text. It does work if the user tabs to the field within the form or if
using the navigation arrows to go from one record to another, but not if they
tab to the end of one record, continue tabbing into the next record, which is
what they will do most often.
Thanks for your help,
Kristine