Cursor Placement

[Guest]

Hello all,

Is there a way (using VB) to force the cursor to move to the end of text
when a field has the focus.

I have the following code which puts the cursor at the start of the field,
but I want to cursor to be at the end of the field:

Private Sub FirstName_GotFocus()
Me!FirstName.SelStart = Me!FirstName.SelLength
End Sub

There does not appear to be a reverse action for SelStart in VB Help which
seems odd.

 

[fredg]

Hello all,

Is there a way (using VB) to force the cursor to move to the end of text
when a field has the focus.

I have the following code which puts the cursor at the start of the field,
but I want to cursor to be at the end of the field:

Private Sub FirstName_GotFocus()
Me!FirstName.SelStart = Me!FirstName.SelLength
End Sub

There does not appear to be a reverse action for SelStart in VB Help which
seems odd.

Me!FirstName.SelStart = Len(Me![FirstName])

 

[Guest]

Fredg,

Wow that was really fast on the draw. Thanks a million

Hello all,

Is there a way (using VB) to force the cursor to move to the end of text
when a field has the focus.

I have the following code which puts the cursor at the start of the field,
but I want to cursor to be at the end of the field:

Private Sub FirstName_GotFocus()
Me!FirstName.SelStart = Me!FirstName.SelLength
End Sub

There does not appear to be a reverse action for SelStart in VB Help which
seems odd.

Me!FirstName.SelStart = Len(Me![FirstName])