Microsoft Access - Customize Keyboard Navigation To Suit Your Work Style (Access 97/2000/2002)
Chances are that you take for granted how your direction arrow and [Enter] keys behave in Access. Typically, 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 forced to accept 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.