Word Search Criteria

J

John C.

I have a memo field in a table that I would like to search
for a "word" that would be user specified.

I would like to show all records on a continuous form that
contain the "word".

WDIB?
 
J

John C.

I have tried the following criteria, but it returns
nothing...

"*" & [Forms]![frmFindWordEntries]![txtWord] & "*"

frmFindWordEntries is a form where the user specifies what
word is to be found.

txtWord is the control where the user types his criteria.
 
J

John Spencer (MVP)

Try putting the word LIKE in front of the criteria

LIKE "*" & [Forms]![frmFindWordEntries]![txtWord] & "*"

If you are using an ADP vice MDB then the wildcard character is a % sign so if
the above fails try:

LIKE '%' & [Forms]![frmFindWordEntries]![txtWord] & '%'
 
Top