SEARCH in Access Forms - can we Edit the Search Options

[alinka]

Hi,

Is there any way to put a code into a form so that when a user clicks on "search":

1) "Search only current field" is always unchecked, and
2) "Match" is always set to --> "any part of field" and NOT "whole field"

Thanks in advance for your help.

 

[Dugantrain]

In the toolbar, go to Tools, Options, Edit/Find, and then select General Search for default Search Behaviour. This will search all fields in your record by default.