Find and Replace: Search Fields As Formatted

[Dean Slindee]

On the Find and Replace dialog box, there is a checkbox at the bottom
labeled "Search Fields As Formatted". What is this supposed to do?

The reason I ask is two-fold:
1. I always tell my users to uncheck this box, because it invariably ruins
the search by returning no rows or hanging.
2. When unchecked, the same search works perfectly.
3. On a table with 370,000 rows, it always hangs. Then you get the option
to cancel the search which really means to terminate the host Access
application. Duh?, why cancel Access when only the search is hung?

Thanks,
Dean Slindee

 

[Van T. Dinh]

From Access Help:
****
The "Search Fiels as Formatted" is used to find datanase based on its
*display* format (for example, a date value 01/05/2005 which is a numeric
value internally, but displayed as 01-May-2005. Searching this way is
slowest. Clear the option to find data based on its value.
****

If you used "Lookup" Fields (not recommended), this option is automatically
selected and you cannot unselect it.

Sorry, I don't know about the second part. I never used this option.