[AccessD] Change default setting on find dialog box

[Rocky Smolin]

That gets me three options: fast search, general search, start of field
search.  What I'm looking for when I do a find or replace (like looking for
a value in a table in datasheet view) is Look in: Current document, Match:
any part of field.

Any way to set that globally?

TIA

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, October 12, 2016 3:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Change default setting on find dialog box

File - Options - Client Settings - Default find/replace behaviour.



On 12 Oct 2016 at 14:39, Rocky Smolin wrote:

> Lambert:
> 
> Thank you.  But I was looking for how to set the options through the 
> Access UI.
> 
> r
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Heenan, Lambert Sent: Wednesday, October 12, 2016 9:27 AM To:
> 'Access Developers discussion and problem solving' Cc: 'Off Topic'
> Subject: Re: [AccessD] Change default setting on find dialog box
> 
> Should be the same as all the previous versions,
> 
> See here for example
> https://bytes.com/topic/access/answers/758233-code-find-replace-defaul
> t-part -field
> 
> 
>     'Set to General Search - Part of Field
>     Application.SetOption "Default Find/Replace Behavior", 1
> 
>       'do whatever you like in here, but Reset Option at some point
> 
>     'Reset to Fast Search - Whole Field
>     Application.SetOption "Default Find/Replace Behavior", 0
> 
> 
> Lambert
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf 
> Of Rocky Smolin Sent: Wednesday, October 12, 2016 10:45 AM To: 'Access 
> Developers discussion and problem solving' Cc: 'Off Topic' Subject:
> [AccessD] Change default setting on find dialog box
> 
> Dear List:
> 
> 
> 
> Is there a way to change the default setting on the find/replace 
> dialog box in Access 2010?  Searched the internets but couldn't find 
> an answer.
> 
> 
> 
> MTIA
> 
> 
> 
> 
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 760-683-5777
> 
>  <http://www.bchacc.com> www.bchacc.com
> 
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
> 
> Skype: rocky.smolin
> 
> 
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com