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. Select Edit > Replace Value in Collection.
  4. In the Replace field, specify the value you want to find and change.

    The Replace Value feature uses what is known as an "implied wildcard" search.

    See Using wildcards.

  5. In the With field, specify the new value you want to use.
  6. Optionally, from the In Collection 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 select Help > About This form to see the name of the current collection.

  7. Optionally, from the In Property 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 you specified, select Case Sensitive.
  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.