XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google

Home
Whats New!
Need a database?
Tips via email
Learn VBA
Questions Answered
Access Tips Index


 
Changing the search default from ‘Whole Field’ to ‘Any Part of Field’

Question

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

To what you ask.  On the toolbar, select the following:

Tools>Options

Then, click on the Edit/Find tab then, in the Default Find/Replace section, choose General Search.

This should do the trick.

 

 

 

Do you like this tip? Subscribe to my free weekly Newsletter to receive tips weekly via email. Click Here to subscribe.

footer for Microsoft Access page