How do I set up a free text search in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have designed a form in Access which contains buttons that run queries on
records in certain categories. What I now need to do is add a free text
search function so that users can type one word in and it will bring back all
records containing that word.

It is a while since I have used Access and and help would be greatly
appreciated.
Many thanks, Sarah
 
would that be for every field in the table, or just a specific field? If it
is one field, then create a query and in the criteria row of the query:

InStr([MyField],[Enter Word]) > 0
 
Back
Top