Wildcard in expression of Condition Formating

[johan]

Hello,

Is it possible to use a wildcard in the expression of a conditional
formating in a form.
I want to highlight the datafield (backgroundcolor) if the datafield
contains, for example,
the letter "z".

In a query you can use: Like "*"&"z"

how to use it in a form as a conditional formating on a datafield.

regards,
Johan

 

[Peter Hibbs]

Johan

Try this :-

Set the first field to Expression Is
and the second field to [YourFieldName] Like "*[z]*"
change YourFieldName to the name of the field you are using, of
course.

HTH

Peter Hibbs.