How do I Query based upon whole word value in form text field

[jdrogers81]

I know how to create a query with a critera operator "Like" that uses a value entered in a form text field. Example:



Like "*" & [Forms]![formName]![txtValue] & "*"

This query criteria searches the entire field for the data entered into the text box on a form. The problem is it returns records where the value entered is part of a word. I only want records that contain the whole word as entered on the form. The field I am querying has multiple words, so I need it to find one WHOLE word in the field as entered in the query.

Current Example: "car" returns"carpal", "carnage", etc.

Desired Example: "car" returns only "car"

Please help!

[jdrogers81]

Thanks to Bob G on UtterAcess Forums for the quick answer!

Bob G wrote:

you would need to include the space before and after. This is untested.

Like "*"& " " & [Forms]![formName]![txtValue] & " " & "*"