Using a search form with the memo format 1

[CalibAndrew]

I'm trying to make a search form in which a word typed into a textbox populates a report with records that have that word in a memo format field (called "Description&quot.

In order to do this, I tried linking the textbox to a macro which brought up a report based on a query of the Description field that had the criteria:

=[Forms]![frmSearch]![txtSearch]

Of course this didn't work (there were no records in the report). I think that the above criteria only brings up whole field matches, which rules out single word searches.

So I guess my questions are:
-Is there a version of that expression I can use to have the query hit on records that have a word in that memo field that the user types in?

And:

-Can you even use a search form with the memo format?

 

[jitter]

have you tried using the 'Like' operator?

I don't know forsure but you might try this:


Like "*" & [Forms]![frmSearch]![txtSearch] & "*"


hope this works....

 

[CalibAndrew]

It worked. Thanks!