Word Search Criteria

  • Thread starter Thread starter John C.
  • Start date Start date
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?
 
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.
 
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] & '%'
 
Back
Top