How search for text in memo columns?

M

mscertified

I have a table containing three memo columns.
User wants to be able to search for records in the table matching on text in
the memo columns.
This should run as quickly as possible.
What is the best technique to use?
 
M

Marshall Barton

mscertified said:
I have a table containing three memo columns.
User wants to be able to search for records in the table matching on text in
the memo columns.
This should run as quickly as possible.
What is the best technique to use?
Click to expand...


Try using a criteria something like:

Like "*" & [Enter search text] & "*"

under each of the three memo fields, Make sure that the
three criteria are in different OR rows.

If you are using a form to enter the search text, change the
above criteria:

Like "*" & Forms![name of form].[name of textbox] & "*"
 
Top