Changing Search Default. I do a lot of "searching" when I am in Access and I was wondering something. Whenever I hit "find" the option always comes up with Match "Whole Field" - I always want it to be "Any Part of Field" instead - is there any place where I can change that option? Minor detail but it's aggravating if you do a lot of searching!
Answer When changing search default, select the following on the toolbar:
Then, click on the Edit/Find tab then, in the Default Find/Replace section, choose General Search.
This should do the trick.