Searches

  • Thread starter Thread starter Dan Nakari
  • Start date Start date
D

Dan Nakari

Can someone tell me how when I click search in a tables / form / or query
how I can make the default in the Match : to always read "any part of the
field" versus the default of "whole field"?

Thanks
 
Tools -> Options -> Edit/Find -> General Search.

However, this also makes it include all fields, not just the current field.
Here's the help clip:

Sets the default behavior of Microsoft Access Find/Replace operations.
Select Fast Search to search the current field and match the whole field.
Select General Search to search all fields and match any part of the field.
Select Start Of Field Search to search the current field and match the
beginning character(s) of the field.
 
Back
Top