Searching memo field via parameter

  • Thread starter Thread starter Shannon
  • Start date Start date
S

Shannon

I would like to allow user to input *<string>* as a query
parameter which Access would then use to search a memo
field. My problem is that in the Criteria field QBE pane,
brackets denote a parameter dialog box AND they also
denote a list of criteria for Access to use in a wildcard
search. I want to use them to create a parameter dialog
box, but Access will not let me input:
LIKE *[Enter value to search]*
in the Criteria field. The brackets interfere with my
logic! Any ideas on how else I can accomplish my goal??

Thanks so much,
Shannon
 
Really close. Try concatenating the Wildcard characters onto the input. See example.

LIKE "*" & [Enter value to search] & "*"
 
Back
Top