• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 33. Working with Records > Finding a Match in a Form or a Table

Finding a Match in a Form or a Table

You can use the Find command to search a form or a table.

To find a match:

1.
Open the form or table that includes the field containing the data you want to find.

2.
Click the field (Figure 33.5).

Figure 33.5. Click a field.


3.
Click the Find button on the Access toolbar (Figure 33.6).

Figure 33.6. Click the Find button.


or

Press Ctrl+F.

or

From the Edit menu, choose Find.

4.
In the Find and Replace dialog box, type the entry you’re looking for in the Find What text box (Figure 33.7).

Figure 33.7. Type a word in the Find and Replace dialog box.


5.
Choose an option from the Look In pull-down list to look only in the current field or in the whole table.

6.
Choose an option from the Match pull-down list to further define the search (whole field, any part of field, or start of field).

7.
Click More to choose other options (search direction and matching case).

8.
Click the Find Next button to find the first match (Figure 33.8).

Figure 33.8. The record shows the first instance of the word.


9.
Click the Find Next button again if the first match is not the one you’re looking for.

10.
Click Cancel to close the Find dialog box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint