By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,871 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

default the find box to match "Any part of field"

P: 19
Is there a way to make the find box (Ctrl+F) default to match "Any part of field" instead of "Whole field".

Thanks in advance.

Jun 4 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
Choose Options from the Tools menu.

On the Edit/Find tab, set:

Default find/replace behavior


General Search

You can set this programmatically with:

Application.SetOption "Default Find/Replace Behavior",1

But this is problematical in that it doesn't take effect until Access is closed then opened again. If someone should manually change the setting on a given machine, in any module of MS Office, it would have to be reset by your Access app again, once again being closed and reopened to take effect.

Welcome to Bytes!

Linq ;0)>
Jun 4 '08 #2

P: 1
Hey, thanks ! it worked for me in Access 2010. By creating a macro called AutoExec with the instruction RunCode and passing it the name of the function (inside a module) that has your code.
Jan 29 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.