Chapter 6: Working with Datasheet View
233
The Paste command’s down arrow gives you three choices:l Paste: Paste inserts the contents of the Clipboard into one field.l (^) Paste Special: Paste Special gives you the option of pasting the contents of the Clipboard
in different formats (text, CSV, records, and so on).
l (^) Paste Append: Paste Append pastes the contents of the Clipboard as a new record —
provided a row with a similar structure was copied.
Tip
Select a record or group of records using the record selector to cut or copy one or more records to the
Clipboard. Then use Paste Append to add them to a table with a similar structure.
Replacing Values
To replace an existing value in a field, you can manually find the record to update or you can use
the Find and Replace dialog box. Display the Find and Replace dialog box using these methods:
l (^) Select the Replace command from the ribbon’s Find group.
l Press Ctrl+H.
This dialog box allows you to replace a value in the current field or in the entire datasheet. Use it
to find a certain value and replace it with a new value everywhere it appears in the field or table.
After the Find and Replace dialog box is active, you should first click the Replace tab and type in
the value that you want to find in the Find What box. After you’ve selected all the remaining
search options (turn off Search Fields As Formatted, for example), click the Find Next button to
find to the first occurrence of the value. To change the value of the current found item (under the
cursor), enter a value in the Replace With box and click the Replace button. For example, Figure
6.10 shows that you want to find the value Mini Vans in the Category field of tblProducts
and change it to Minivans.
FIGURE 6.10
The Find and Replace dialog box with the Replace tab showing. In this case, you want to replace Mini
Vans with Minivans.