You, probably. take for granted how your direction arrow and Enter keys behave in Access.
When you press Enter the focus moves to the next field and the contents of the field are selected. Likewise, when you press the direction arrow keys, the focus moves to the next field in the appropriate direction. You aren't locked into these behaviors.
If you'd like, you can set up the arrow keys to move from one character to the next in the current field, rather than moving focus to the next field.
You can also configure the Enter key to move to the next record when it's pressed or configure it to do nothing at all.
When you do move focus to another field, you have the option to place the insertion point at the beginning or end of the field, rather than selecting the field's entire contents.
To modify these settings, choose Tools>Options from the menu bar and click on the Keyboard tab. Then, simply make the selections you want and click OK.
In 2007 it's under Access Options>Advanced when you click the Logo in the upper left corner.