Hi All,,

When I using the find function(Ctrl F), the check box of "Search Fields As
Formatted" is defaulted a tick sign. How to make it default as unchecked?
For this result, I can't find a single digit record number by using "001"
format.

I thought that Application.SetOption might do the trick. Something like
below can change the Find/Replace behavior.

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

However this does not work:

Application.SetOption "Search Fields As Formatted", False

Sorry.

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"vintang99" wrote:

> Hi All,,
>
> When I using the find function(Ctrl F), the check box of "Search Fields As
> Formatted" is defaulted a tick sign. How to make it default as unchecked?
> For this result, I can't find a single digit record number by using "001"
> format.