Default the field - Search Fields As Formatted in Acess 2003

V

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.
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace: Search Fields As Formatted 1
how to turn off search fields as formatted feature in ms access 1
workaround to set "Search Fields as Formatted" 1
Using the find action 1
Search Fields As Formatted in MSAccess2003 1
How to format fields formatted as number the way I enter the numbe 10
when i move single field in form design all fields move 1
Search Multiple Fields From Same String 6

Top