Microsoft Access 2010 Bible

Chapter 6: Working with Datasheet View

231

Caution
Pressing Ctrl+– (minus sign) deletes the current record.

Changing an existing value

If you want to change an existing value instead of replacing the entire value, use the mouse and

click in front of any character in the field to activate Insert mode; the existing value moves to the

right as you type the new value. If you press the Insert key, your entry changes to Overstrike

mode; you replace one character at a time as you type. Use the arrow keys to move between char-

acters without disturbing them. Erase characters to the left by pressing Backspace, or to the right of

the cursor by pressing Delete.

Table 6.2 lists editing techniques.

TABLE 6.2

Editing Techniques

Editing Operation Keystrokes

Move the insertion point within a field Press the right-arrow (→) and left-arrow (←) keys

Insert a value within a field Select the insertion point and type new data

Select the entire field Press F2

Replace an existing value with a new value Select the entire field and type a new value

Replace a value with the value of the previous field Press Ctrl+’ (single quote mark)

Replace the current value with the default value Press Ctrl+Alt+Spacebar

Insert a line break in a Text or Memo field Press Ctrl+Enter

Save the current record Press Shift+Enter or move to another record

Insert the current date Ctrl+; (semicolon)

Insert the current time Ctrl+: (colon)

Add a new record Ctrl++ (plus sign)

Delete the current record Ctrl+– (minus sign)

Toggle values in a check box or option button Spacebar

Undo a change to the current field Press Esc or click the Undo button

Undo a change to the current record Press Esc or click the Undo button a second time

after you undo the current field