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

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

matthardwick
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.

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


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

On the Edit/Find tab, set:

Default find/replace behavior

to:

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.