Selecting, Appending, Replacing, and Deleting Table Records

You can select a single record or a group of records to copy or cut to the Clipboard, or to delete from the table, by the following methods:

• To select a single record, click its record selection button.

• To select a contiguous group of records, click the first record's selection button and then drag the mouse pointer along the record selection buttons to the last record of the group.

• Alternatively, to select a group of records, click the first record's selection button and then Shift+click the last record to include in the group. You can also press Shift+ to select a group of records.

You can't use Ctrl+click to select discontiguous records.

Note

You can cut groups of records to the Clipboard, deleting them from the table, but you can't cut data blocks. A group of records includes all fields of one or more selected records. A data block consists of a selection in a table datasheet that doesn't include all fields of the selected rows. The Edit, Cut command is enabled for groups of records and disabled for data blocks.

You can cut or copy and append duplicate records to the same table (if appending the duplicate records doesn't cause a primary-key violation) or to another table. You can't cut records from a primary table that has dependent records in a related table if you enforce referential integrity. The following methods apply to appending or replacing the content of records with records stored in the Clipboard:

• To append records from the Clipboard to a table, choose Edit, Paste Append. (No shortcut key exists for Paste Append.)

• To replace the content of a record(s) with data from the Clipboard, select the record(s) whose content you want to replace and then press Ctrl+V. Only the number of records you select or the number of records stored in the Clipboard (whichever is fewer) is replaced.

To delete one or more records, select those records and press Delete. If deletion is allowed, a message box asks you to confirm your deletion, if you haven't cleared the Confirm Record Changes text box on the Edit/Find page of the Options dialog. You can't undo deletions of records.