Microsoft Office Tutorials and References
In Depth Information
Working with Records
Search text Text found in record
The Find and Replace dialog box.
3. In the Find What box, enter what you’re
Searching from the Search box.
4. Choose from the additional options as
Look in: Choose whether you want to
search in the current field or the
current document, which includes the
The second method has you use the Find
command. The Find command is useful when you want
to seek out text that you may have trouble visually
locating. The Find command doesn’t change any
text; it simply locates and highlights the specified
text for you. And with the Find command, you
have a number of options from which you can
choose. The Find command is easiest used with the
Match: Choose from Whole Field,
which means the text you entered in
Step 3 is the complete and only word
(or phrase) in its field. With Whole field
selected, entering Jet will not find
Jetson . Choose Any Part of Field if you
mean the text entered in Step 3 is just a
portion of the field. For example, if you
enter read in the Find box, Access will
also locate words like bread or reading .
Follow these steps:
Open the table or form you want to search.
Search: Select a direction to search.
Choices are Up, Down, or All. If you
choose up or down, Access searches
from the point of the current record.
2. Choose Home>Find>Find or press Ctrl+F
which displays the Find and Replace dialog
box you see in Figure 18-26.
Match Case: Check this to locate
instances that match the uppercase and
lowercase letters as you entered in the
Find box. For example, if you typed West ,
Access will not locate west or WEST .