Default the field - Search Fields As Formatted in Acess 2003

[vintang99]

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.

 

[Jerry Whittle]

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.