Office 2007 Bible

Changing Values in a Datasheet

If the field that you are in has no value, you can type a new value into the field. When you enter new values into a field, follow the same rules as for a new-record entry.

Generally, you enter a field with either no characters selected or the entire value selected. If you use the keyboard (Tab or Arrow keys) to enter a field, you select the entire value. (You know that the entire value is selected when it is displayed in reverse video.) When you begin to type, the new content replaces the selected value automatically.

When you click in a field, the value is not selected. To select the entire value with the mouse, use any of these methods:

• Click just to the left of the value when the cursor is shown as a large plus sign.

• Double-click in the field. (This only works if the field doesn’t contain spaces.)

• Click to the left of the value, hold down the left mouse button, and drag the mouse to select the whole value.

• Click in the field and press F2.

Tip

You may want to replace an existing value with the value from the field’s Default Value property. To do so, select the value and press Ctrl+Alt+Spacebar. To replace an existing value with that of the same field from the preceding record, press Ctrl+’ (single quote mark). Press Ctrl+; (semicolon) to place the current date in a field.

Caution

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

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