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:
-
Open the form and display the collection you want.
-
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.
-
Select .
-
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.
-
In the With field, specify the new
value you want to use.
-
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 to see the name of the
current collection.
-
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.
-
To find and replace a value only if it has the exact capitalization
you specified, select Case Sensitive.
-
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.
-
Click OK.
-
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.