I'm having a very bizarre problem. I open up my table in datasheet
view, and I click on edit, find. In the Find and Replace dialog box, I
enter an address (123 main for example). If I set the Look In
parameter to a specific field (Mailing Address), my record is found.
If I go back up to the top of the table, and set the Look In parameter
to my table name to search all of the fields in the table so that I can
also search the Street Address, no record is found. I have Match set
to any part of field, Search is set to All, and and Match Case is
unchecked. I'm sure I'm missing something stupid, but I can't figure
it out. Any ideas?