Find/Replace Default setting

[LloydCall]

change default for find/replace button from "Whole Field" to "Any Part of Field" in Microsoft 365 Access

 

[Jon]

Welcome to the forums! We are the most active Microsoft Access community on the internet by far, with posts going back over 20 years!

To get started, I highly recommend you read the post below. It contains important information for all new users to this forum.

https://www.access-programmers.co.uk/forums/threads/new-member-read-me-first.223250/

We look forward to having you around here, learning stuff and having fun!

 

[LloydCall]

I've used access for years in Utah, but the latest version doesn't work for Office 365 Access.
Here is the answer posted, in Office 365 there IS NO TOOLS BUTTON

Question:
Find and replace default settings
Is there any way to change the default settings on the Find and Replace dialog from 'Whole field' to 'Any part of field'?

Answer:

Tools | Options
Click on Edit/Find tab.
There is a section called Default find/replace behavior.
Click the General search radio button.

 

[theDBguy]

Hi. Welcome to AWF!

Just FYI, I have moved and merged your threads out of the Introduction Forum.

 

[CJ_London]

So far as I know you can’t change the default- you would need to write you own to either step through the form recordset or use an update query