Search Memo Field using Query Builder

[b dubbin]

How do I search a memo field as a partial string as defined by a use
entered on a form using a query?

Here's what I mean...

- I have a form (frmReport).
- frmReport has a textbox (txtDescription)
- A user can enter a string of words into the textbox.

- I have a query (qryDescription)
- qryDescription has a field (fdDescription) from a tabl
(tblDescription).
- fdDescription field has a Data Type of 'Memo'.

- I want to place criteria on the qryDescription query based o
whatever the user enters in the textbox txtDescription on the frmRepor
form.

Within the query builder as 'Criteria' for fdDescription I tried:

Like "*[Forms]![frmReport]![txtDescription]*"

The query runs but no values are returned when a word(s) is inputted o
the frmReport that contains a word in tblDescription.

What should I type in the Criteria box of the query (or what's the SQL
that I need to use?

Thanks in advance..

 

[Steve Schapel]

B Dubbin,

Try it like this...
Like "*" & [Forms]![frmReport]![txtDescription] & "*"

 

[b dubbin]

Thank you Steve.