search in a notes field

S

Striker

I know I can place square brackets in a query to get the users input, but
what if I want to look for whatever they input in the string of a notes
field, and if found return those records. Access 2007.
 
R

RonaldoOneNil

In the criteria row of your Notes Field put

Like "*" & [Enter Search String] & "*"
 
Top