Results 1 to 5 of 5
  1. #1
    mcalder4 is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    13

    How to change Default Option in "Find" dialogue box

    I use the "Find" (Binoculars) function a lot. It always opens with the Option "Whole Field" selected and I always have to change it to "Any Part Of The Field". How can I set this so that it always opens with "Any Part Of The Field" already selected?

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    I would be interested in this as well.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    For v 2007, in Options > Advanced change "default find/replace behavior" to General Search
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    For v 2007, in Options > Advanced change "default find/replace behavior" to General Search
    In 2010 it can be found under Client Settings>Editing. Also found this link which gives some code

    https://bytes.com/topic/access/answe...any-part-field

  5. #5
    mcalder4 is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Posts
    13
    Have now found the answer. In Access 2013 go to File / Options / Client Settings: Under the first section "Editing" locate Default find/replace behavior and select "General search". After closing and then restarting Access the Default Find function will be set to "Any Part Of The Field".

    Problem Solved!!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 04-20-2016, 02:50 PM
  2. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  3. Replies: 30
    Last Post: 09-27-2013, 01:34 PM
  4. Replies: 1
    Last Post: 09-19-2013, 11:42 AM
  5. Replies: 16
    Last Post: 07-22-2011, 09:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums