Replacing a Value in a Record

You can search a collection for records that contain certain field values and replace them with new values.

To replace a field value in a collection:

1. Open the form and display the collection you want.
2. Place the cursor in the field for which you want to replace values. Note that, in a grid, the replacement only looks at records below the current cursor position.
3. From the Edit menu, select Replace Value in Collection.
4. In the Replace dialog box, Replace field, type the value you want to find and change.

   The Replace Value feature uses what is known as an "implied wildcard" search. For more information, see Implied Wildcards.

5. In the With field, type the new value you want to use.
6. (Optional) From the In Collection drop-down list, select the name of the collection you want to search.

   If you placed the cursor in the desired field before starting, the correct collection should already be selected.

   If you do not know the name of the collection, return to the form and click the section displaying the collection. Then click Help > About This form to see the name of the current collection.

7. (Optional) From the In Property drop-down list, select the name of the field in which you want to make replacements.

   If you placed the cursor in the desired field before starting, the correct property should already be selected.

8. To find and replace a value only if it has the exact capitalization as you typed it, select the Case Sensitive check box.
9. To replace the value in this field regardless of the current value, select the All Values check box. The Replace field is deactivated, indicating that any value in the field will be replaced.
10. Click OK.
11. When prompted, click one of these buttons:
    • To replace only the currently selected and displayed field value, click Yes.
    • To skip the currently selected and displayed field value and move to the next one, click No.
    • To cancel the operation and make no replacements, click Cancel.
    • To replace all values for this field in the collection, click Yes to all.

Related Topics

Working with Records

About Adding, Changing, and Deleting Records

Locating Specific Information in Records

Using Wildcard Characters