Use shortcut keys to edit text or data
Note If the insertion point isn't visible, press F2 to display it.
Moving the insertion point in a field
- RIGHT ARROW
- To move it one character to the right
- CTRL+RIGHT ARROW
- To move it one word to the right
- LEFT ARROW
- To move it one character to the left
- CTRL+LEFT ARROW
- To move it one word to the left
- END
- To move it to the end of the field, in single-line fields
- CTRL+END
- To move it to the end of the field, in multiple-line fields
- HOME
- To move it to the beginning of the field, in single-line fields
- CTRL+HOME
- To move it to the beginning of the field, in multiple-line fields
Copying, moving, or deleting text
- CTRL+C
- To copy the selection to the Clipboard
- CTRL+X
- To cut the selection and copy it to the Clipboard
- CTRL+V
- To paste the contents of the Clipboard at the insertion point
- BACKSPACE
- To delete the selection or the character to the left of the insertion point
- DELETE
- To delete the selection or the character to the right of the insertion point
- CTRL+DELETE
- To delete all characters to the right of the insertion point
Undoing changes
- CTRL+Z or ALT+BACKSPACE
- To undo typing
- ESC
- To undo changes in the current field or current record; if both have been changed, press ESC twice to undo changes, first in the current field and then in the current record
Entering data in Datasheet or Form view
- CTRL+SEMICOLON (;)
- To insert the current date
- CTRL+SHIFT+COLON (:)
- To insert the current time
- CTRL+ALT+SPACEBAR
- To insert the default value for a field
- CTRL+APOSTROPHE (')
- To insert the value from the same field in the previous record
- CTRL+PLUS SIGN (+)
- To add a new record
- CTRL+MINUS SIGN (-)
- To delete the current record
- SHIFT+ENTER
- To save changes to the current record
- SPACEBAR
- To switch between the values in a check box or option button
- CTRL+ENTER
- To insert a new line
Refreshing fields with current data
- F9
- To recalculate the fields in the window
- SHIFT+F9
- To requery the underlying tables; in a subform, this requeries the underlying table for the subform only
- F9
- Refresh the contents of a Lookup field list box or combo box