Access default to "any part of a field" in search

's Computer Specifications

My access Data base defaults to "whole Field" in search mode. How do I get
it to default to "any part of the field"?

's Computer Specifications

Try:
Application.SetOption("Default Find/Replace Behavior", 1)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"focusben" <(E-Mail Removed)> wrote in message
news:30AA2D2C-21FD-42F1-A84C-(E-Mail Removed)...
> My access Data base defaults to "whole Field" in search mode. How do I
> get
> it to default to "any part of the field"?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
search web part security error net 2008 search server express	cindy	Microsoft ASP .NET	0	14th Aug 2009 09:51 PM
Search/Match/Find ANY part of string to ANY part of Cell Value	TWhizTom	Microsoft Excel Worksheet Functions	0	21st Jul 2008 08:16 PM
Security for an ADP; what is Access part? What is SQL server's part.	computer.mike@hotmail.com	Microsoft Access Forms	1	30th Oct 2007 02:01 AM
how do I search for a contact using part of first name and part o.	=?Utf-8?B?UmF2aSBNdXJ0aHk=?=	Microsoft Outlook Contacts	1	19th Jan 2005 11:40 PM
Change code to search from"first part of field " to "any part of field"	mrmajix	Microsoft Access Form Coding	1	15th Nov 2003 04:22 PM