Use "Like" function in conditional formatting on form.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi folks,

Is it possible to use the "Like" function in an expression for a
conditional formatting rule.

e.g.
Like "*" & [Forms]![myform].[myfield] & "*"

I have a field that always contains either value X or value Y but has
additional information concatenated onto it that changes, and I would
like the field to be blue for value X and green for value Y.

Thanks - David

.