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] & '%'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search for a word in a memo field ? 3
Access Dcount (multiple criteria) 3
Multiple Parameters to search a field 1
Filtering a table by using criteria in another table 1
Word VBA for deleting Selected Row 0
Multiple Parameters to search a field 1
NOT LIKE search criteria 13
Query for exact word 8

Back
Top