Searching memo field via parameter

[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

 

[John Spencer (MVP)]

Really close. Try concatenating the Wildcard characters onto the input. See example.

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

 

[John Vinson]

You can do it using

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