searching further then first word in memo field

  • Thread starter Thread starter Ren
  • Start date Start date
R

Ren

Hi all

I need to search a memo field that holds descriptions of software programs
eg if the user is looking for a like a zip program but cant remember its
name
they can input "zip" and search through the description and return each that
contain that word or variant (zipping)

like [type word here] & * only searches the 1st word of the field


cheers
thanks
 
You want:

[memo field] Like "*" & [type word here] & "*"

or:

Instr ([memo field], [word]) > 0
(but check the order of the two parameters;
I don't have Access here to check).

TC
 
Back
Top