Replace Dialog Box

Use this dialog box to replace values in a field with a new value that you specify.

NOTES:

The search works beginning with the selected record and going on from there. It does not loop back through the beginning of the records. This means that, if you want to search only the last part of a collection, you can start with the focus on the first record from which you actually want to search.
When you use this dialog box, and click OK, the system prompts you and queries whether you want to change an individual value found, or all values that match the criteria. This allows you to selectively replace values only in certain records (by selecting Yes or No) or in all records at once (by selecting Yes to All).

Dialog Box Elements

The following table lists the elements of this dialog box and explains their use.

Element	Function/Comments
Replace	Enter the value that you want to find and replace. The Replace Value feature uses what is known as an "implied wildcard" search. For more information, see Implied Wildcards.
All Values	To replace the contents of a particular field in all records, regardless of the field's current values, select this check box. To selectively replace the contents of a field only if it contains the value you entered in the Replace field, clear this check box.
With	Enter the value you want to replace the value you entered in the Replace field with.
In collection	From the drop-down list, select the name of the collection you want to search. If you do not know the name, return to the form and click About This Form on the Help menu to see the name of the current collection.
In property	From the drop-down list, select the name of the field you want to search. The default value for this field is whatever field the cursor was in when you opened this dialog box. So, to have the field in which you want to replace values preselected here, make sure that field is selected when you open this dialog box.
Case-sensitive	To find records that have the exact capitalization you typed, select this check box. For example, to find any value that contains the string "test", regardless of case, you might enter Test and clear this check box. This would locate values such as Test case, Amy's testing results, Sales Contest. If, however, you entered Test and selected this check box, the search would find only Test case from the previous list of results.

Element

Function/Comments

Replace

Enter the value that you want to find and replace.

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

All Values

To replace the contents of a particular field in all records, regardless of the field's current values, select this check box.

To selectively replace the contents of a field only if it contains the value you entered in the Replace field, clear this check box.

With

Enter the value you want to replace the value you entered in the Replace field with.

In collection

From the drop-down list, select the name of the collection you want to search.

If you do not know the name, return to the form and click About This Form on the Help menu to see the name of the current collection.

In property

From the drop-down list, select the name of the field you want to search.

The default value for this field is whatever field the cursor was in when you opened this dialog box. So, to have the field in which you want to replace values preselected here, make sure that field is selected when you open this dialog box.

Case-sensitive

To find records that have the exact capitalization you typed, select this check box.

For example, to find any value that contains the string "test", regardless of case, you might enter Test and clear this check box. This would locate values such as Test case, Amy's testing results, Sales Contest.

If, however, you entered Test and selected this check box, the search would find only Test case from the previous list of results.

How to Get There

Select the first record in the collection.

Place the cursor in the text field (or other field in which you can type in values) for which you want to find and replace some value.

From the Edit menu, select Replace Value in Collection.

Replace Dialog Box

Dialog Box Elements

How to Get There

Related Topics