articles

Home / DeveloperSection / Articles / Edit text and data shortcut keys in MS Access

Edit text and data shortcut keys in MS Access

Vijay Shukla2751 04-Apr-2013

In this article I am trying to explain shortcut keys for Edit text and data in MS Access.

Moving the insertion point in a field
Key
Description

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
Key
Description

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
Key
Description

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


Updated 29-Nov-2017

Leave Comment

Comments

Liked By