To move through records one at a time, use the scroll bar arrows in the dialog box. To move through 10 records at a time, click the scroll bar between the arrows.
To move to the next record in the list, click Find Next. To move to the previous record in the list, click Find Prev.
To set search conditions, or comparison criteria, click Criteria, then enter the criteria into the data form. To find records that match the criteria, click Find Next or Find Prev. To return to the data form without searching for records based on the criteria you specified, click Form.
Wildcard characters you can use as criteria
The following wildcard characters can be used as comparison criteria for filters, and when searching and replacing content.
| Use |
To find |
| ? (question mark) |
Any single character
For example, sm?th finds "smith" and "smyth" |
| * (asterisk) |
Any number of characters
For example, *east finds "Northeast" and "Southeast" |
| ~ (tilde) followed by ?, *, or ~ |
A question mark, asterisk, or tilde
For example, fy91~? finds "fy91?" |