set cursor to last character as opposed to selecting contents of the field

[harleyskater]

I was wondering if there was a setting in Access 2007 where you can make it so when you tab through fields on a form or use your mouse to select a text field on a form that the cursor will go automatically to the end of the last character. Access 2007's default is highlight or select the contents of the field.

I will continue looking, thought this might speed it up thank youuuu guys

 

[harleyskater]

found it advanced section under access options! w00t
Behavior entering field
The options in this section change the behavior of the ENTER, TAB, and arrow keys when you use them to move the cursor from field to field in forms and datasheets.

Select entire field Selects the entire field when the cursor enters that field.
Go to start of field Moves to the start of the field when the cursor enters that field.
Go to end of field Moves to the end of the field when the cursor enters that field.

 

[aian]

How can I do exactly the same thing when in Access 2003?

 

[aian]

OK, found it.

Me!FIELDNAMEHERE.SelStart = Me!FIELDNAMEHERE.SelLength

 

[missinglinq]

That works for a single field. It's need to go in the control's GotFocus event as well as the OnClick event.

To do it for all controls in your database you'd do the same thing Harley did:

Tools - Options - Keyboard

and set Behavior on entering field.