Specify how the insertion point behaves

  1. On the Tools menu, click Options, and then click the Keyboard tab.
  2. Do one of the following:

ShowSpecify whether you move to the next character or the next field when you press an arrow key

  • Under Arrow key behavior, do one of the following:

To move the insertion point to the next or previous field after you press the RIGHT or LEFT ARROW key, click Next field.

To move the insertion point to the next or previous character after you press the RIGHT or LEFT ARROW key, click Next character.

 Note   If you select Next field under Arrow key behavior, you can still move the insertion point within a field by pressing F2.

ShowPrevent the insertion point from moving to another record when you press the RIGHT or LEFT ARROW key

  • Do one of the following:

To lock the cursor within the current record, select the Cursor stops at first/last field check box. This prevents the insertion point from moving from the first or last field to the previous or next record when you press the RIGHT or LEFT ARROW keys.

To allow the insertion point to move from record to record, clear the Cursor stops at first/last field check box.

ShowSpecify how the insertion point behaves when you move to another field

You can specify the location of the insertion point when pressing the ENTER, TAB, or arrow keys to move from field to field on forms and datasheets.

  1. Under Arrow key behavior, click Next field.
  2. Under Behavior entering field, do one of the following:

To select the entire field when you enter it, click Select entire field.

To place the insertion point at the start of the field when you enter it, click Go to start of field.

To place the insertion point at the end of the field when you enter it, click Go to end of field.

ShowSpecify how the insertion point behaves when you press ENTER

  • Under Move after enter, do one of the following:

To keep the insertion point in the current field after you press ENTER, click Don't move.

To move the insertion point to the next field after you press ENTER, click Next field.

To move the insertion point to the current field of the next record after you press ENTER, click Next record.

 Note   These settings do not apply to data access pages (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.).

 
 
Applies to:
Access 2003