Home » Microsoft Access » 09 - Forms and Queries
9

A Simple Search on a Single Field

Now that you know how forms can be used to display and edit data, find out how forms can be used to search for data or sort data in datasheets.

  1. Select a field.
  2. In the Edit menu, click Find.

OR

Press Ctrl+F

  1. The Find and Replace dialog box opens.

  1. In the Find What text box, type your data.

NOTE: By default, MS Access will search the field where the insertion point was. You can include wild card characters to perform a generic search. To select the entire table, select the table or query name from the Look In dropdown list box.

  1. MS Access will search all records from the top of the record set. Select Up or Down from the drop-down list to direct the upwards or downwards from the current record position.

  1. Select Match Case to locate an exact match for the uppercase and lowercase alphabets of the text that you typed.

  1. Click Next to start searching from current records.
  2. When you click Find Next, MS Access moves to the next value it finds, and loops to the top of the record-set to continue the search.

Discuss this in the forums

< Prev
|
Next >