It sounds like you want to tab into a text field and have the cursor appear at the end of the line. I Googled and this is what I got:

Private Sub YourTextBoxName_Enter()
    ' Moves the cursor to the end of the existing text
    With Me.YourTextBoxName
        .SelStart = .SelLength
    End With
End Sub

I tested it on one of my existing forms, but I put it on the "Got Focus" event and it works. I think I'll keep it too, thanks for the great idea!

Nope, copied wrong thing here's what I got (what I get for closing a window and re-searching something):

Private Sub YourTextBoxName_GotFocus()
    'Check if the text box has data to avoid errors
    If Not IsNull(Me.YourTextBoxName) Then
        'Move the cursor position to the length of the string
        Me.YourTextBoxName.SelStart = Len(Me.YourTextBoxName.Value)
    End If
End Sub

Also, if you're just editing in the form manually, if you tab into a cell and everything is highlighted, you can press "F2" to drop to edit mode and it will put the cursor at the end of the text.

Donald That's good to know, thanks!

David  Make sure the Insert key on your keyboard is turned on.  That is most likely the cause based on your description.  With the Insert key off, you type over whatever the cursor is highlighting.  With the Insert key on, the cursor is a thin vertical line that doesn't type over anything.  Keyboards don't an LED indicating the on/off state of the Insert key like they do with the Num Lock and Caps Lock keys, so be certain it's on.  Thin vertical cursor: Insert on.  Blocky black cursor: off.

Thank you Kevin, that worked!