472,336 Members | 1,274 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,336 software developers and data experts.

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

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
6 23889
3,532 Expert 2GB
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
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
3 2Bits
Jump ahead 10 years to Access Microsoft 365.
Open up the database without even opening a table.

Top row Select Database Tools
"what do you want to do?" type OPTIONS - hit enter
Select Client Settings->Default Find/Replace Behavior
Select the General Search radio button
Press OK.

You have changed that default that not everyone would choose. AKA -driving them nuts!
Dec 29 '20 #4
3,653 Expert Mod 2GB
Race Shooter,

NICE!!! Never thought to look there!
Dec 29 '20 #5
32,511 Expert Mod 16PB
You have changed that default that not everyone would choose. AKA -driving them nuts!
That's a very valid consideration - especially for changing options in code of course.

However, in this case instructions are offered to allow the user to make the choice consciously and with full awareness of what they're doing. If they don't like it then they simply choose not to do it.

The OP (Original Poster) has asked for help in order to make this change. The help was provided for them. It may also help countless others looking for the same thing. Anyone who chooses to follow these instructions, in spite of not actually wanting the same setup, needs help far beyond the scope of this website to handle wouldn't you say?
Dec 29 '20 #6
1 Bit
Thanks for the office 365 explanation, I needed this badly :)
2 Weeks Ago #7

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

Similar topics

by: John Davis | last post by:
I want to know what's the differences between Request.Form("Field Name") and Request.QueryString("Field Name") OR they function exactly the...
by: Omkar Singh | last post by:
I am using XmlSerialization and XmlDeserialization for making soap Body part. Then I am making sopa-header and other part of soap envelope manually....
by: Jaunedeau | last post by:
I have some XML that must look like this : <movies> <movie id="1"> <actor preferredMovieId="1"> <actor preferredMovieId="2"> <actor...
by: AA Arens | last post by:
When I place a record serch utility (vos the button placement wizzrd), I discovered that the Match setting is "Whole Field" by default. How to make...
by: Chris LaJoie | last post by:
Our company has been developing a program in C# for some time now, and we haven't had any problems with it, but just last night something cropped up...
by: Charlie | last post by:
Hi: I'm using the HTML File Field control as a file picker for uploading files to a SQl Server image field. When page posts back to initiate...
by: John Saunders | last post by:
I don't have time for a reproducer now, but I thought I'd post this and then go vent. I'm very angry. <wsdl:message name="OpSoapIn"> <wsdl:part...
by: PW | last post by:
Hi, What the heck is that supposed to mean? I am getting this error on a "Me.Requery" line in a subroutine on a form, but only when I select...
by: mknoll217 | last post by:
I am recieving this error from my code: The multi-part identifier "PAR.UniqueID" could not be bound. The multi-part identifier "Salary.UniqueID"...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.