Find and Replace Options
In the Find and Replace window, the options on the Find and Replace tabs are almost the same. The only differences are that the Replace tab has additional Replace options. The following table describes all of the options that can appear on the Find and Replace tabs.
|
Option
|
Availability
|
Description
|
|---|---|---|
|
Find what
|
Find tab and Replace tab
|
The string of characters to locate. If this leave this option blank, fields without any data are found. Because the last 20 search strings you enter are saved, you can use the drop-down control to select one. The search is based on the active table and your selection for Look in. When a match is found, the record containing this text string is selected in the active table or form. To search for the next occurrence of this text string, you click Find Next.
|
|
Replace with
|
Replace tab only
|
The string of characters to replace those specified for Find what. As many as your last 20 replace strings are remembered. When a match is found, you click Replace to replace the search string with the replace string. If Replace with is left blank, the string specified is replaced with blanks, thereby deleting the occurrence. To replace all occurrences of the search string with the replace string, you click Replace All.
|
|
Look in
|
Find tab and Replace tab
|
Indicates the field or fields to search. If the field selected in the active table or form is enabled, it is the default. For example, if Description is selected in the FRACAS Incidents table, Description is the default. All Fields or All Enabled Text Fields is also available. All Fields is a choice on the Find tab. All Enabled Text Fields is a choice on the Replace tab. When one of these choices is selected, all fields in the active table or form that are not attached to lists are searched.
|
|
Match
|
Find tab and Replace tab
|
Indicates what constitutes match. Three choices are provided for specifying what constitutes a match:
• Any Part of Field. When selected, a match is found if the text string occurs in any part of the field. For example, if test is entered, occurrences of “test” are found. Occurrences of “Testability analysis,” “Perform test,” and “Perform tests for contamination” are also found.
• Whole Field. When selected (default), a match is found only if the text string exactly matches all words in the field. For example, if test is entered, occurrences of “test” are found, but occurrences of “test failed” and “Perform test” are not found.
• Start of Field. When selected, a match is found if the text string occurs at the beginning of the field. For example, if test is entered, occurrences of “test” and “Testability analysis” are found, but occurrences of “Perform test” are not found.
|
|
Search
|
Find tab and Replace tab
|
Indicates the direction of the search. Choices are:
• All. When selected (default), the text string is searched for in all records. The search begins at the current record. When the last record is reached, the search begins again at the first record and concludes when the current record is reached.
• Down. When selected, the text string is searched for in the current record and all subsequent records. When the last record is reached, a window opens, asking whether you want to continue the search from the beginning. If you click Yes, the search begins again at the first record and concludes when the current record is reached. If you click No, the search ends.
• Up. When selected, the text string is searched for in the current record and all previous records. When the first record is reached, a window opens, asking whether you want to continue the search from the end. If you click Yes, the search begins again at the last record and concludes when the current record is reached. If you click No, the search ends.
|
|
Match case
|
Find tab and Replace tab
|
Indicates whether the search is case-sensitive. When this checkbox is cleared (default), the case in which the text string is entered is ignored. When this checkbox is selected, the case in which the text string is entered is considered so that only instances where the case matches are found.
|
 |
Find tab and Replace tab
|
When clicked, the search for the entered text string starts or resumes. A progress control reflects the status of the search. For more information, see Search Progress Control.
|
 |
Find tab and Replace tab
|
When clicked, the Find and Replace window closes. The text strings entered for Find what and Replace with are used as the defaults when the Find and Replace window next opens. To search for the next occurrence of this text string without opening the Find and Replace window, press F3.
|
 |
Replace tab only
|
When clicked, the found search string is replaced with the string entered for Replace with, and the search for another match begins. If a search has not been performed, clicking this button starts the search. This button is available on the Replace tab only after a string is entered in Replace with.
|
 |
Replace tab only
|
When clicked, all occurrences of the search string are replaced with the string entered in Replace with. This button is available on the Replace tab once text is entered in Replace with. The search begins with the first record and concludes with the last record, with all found occurrences replaced. Because this action cannot be undone, the Verify Replace window opens. You must click Yes to replace all occurrences of the search string. When the search is finished, the Replace All Complete window opens, indicating the number of replacements that were made. For more information, see Replace All Complete Window.
|
 |
Find tab and Replace tab
|
When clicked, the search is stopped. This button is available only when a search is in progress.
|