Query Criteria Help

[pkarnowski]

I want to put a criteria condition that will ask you to type in lets say 4 letters so it pulles the data that has that word in it. I know I can use
LIKE"*fish*" to get everything with the word fish in it but I want to be able to type the 4 letters in to find it. I have tried ???? but only get the ones that have exactly "fish" in it but I need the ones that also say "fish and chips"

 

[pkarnowski]

I found one way to do it and that was to have the person looking for the data put a * before and after. I put the instructions in [ ] when the box pops up.
Thanks

 

[buckeye_td]

So that you don't have to rely on the user to enter the wildcards, you could put this in the criteria:

Like CStr("*" & [PartOfSearchWord] & "*")

TD