Access Tables

[Guest]

I am using the search function (CTRL +F) on the keyboard. When the "Search"
dialog box is displaed, I type information that is within a cell within a
particular record and search for "Any part of the field." I also choose the
appropriate field name under "Look In:" When I click the search button, I
receive an error message saying that it can not find that particular cell
within that given record, meanwhile, I can see the record that I am trying to
perform a search on when I look at the table. Is this a service pack issue
or an issue with the table or database or all three?

Please respond.

Thank you!

 

[Dave M]

This can be a formatting issue: try selecting the "As Formatted" option.

 

[Van T. Dinh]

There may be problems if the Field you are searching is the LookUp Fields.
The problem with LookUp Fields is that what you see is _not_ what is stored
in the Table.