How to change FindRecord to a default of "Any Part of Field" (1 Viewer)

chablups

Registered User.
Local time
Today, 13:17
Joined
Feb 2, 2002
Messages
88
When in forms view and searching for a record, is there any way to set the default after clicking on FIND, to "Any Part of Field" instead of "Whole Field"
Thanks.
 

chablups

Registered User.
Local time
Today, 13:17
Joined
Feb 2, 2002
Messages
88
Here's the answer

For anyone that's interested, I found the answer myself. Go to Tools menu, click options. Then click Edit/Find. Then under Default find/replace behavior, chose General Search to search all fields and match any part of the field. NOTE: Changes made to this setting don't take effect until the next time you start Access.
 

Oldsoftboss

AWF VIP
Local time
Today, 22:17
Joined
Oct 28, 2001
Messages
2,499
Good Stuff :)
 

Users who are viewing this thread

Top Bottom