conditional formatting a text field

[babs]

not sure what i am missing
I have a position field that if the word 1st is anywhere in it I want it to
turn red. It is a text data type

I have tried field value is equal to like '*1st*' just '*1st*' not sure
what I am doing wrong??? - not turning red.- and yes I se the formatting to
red??

I am sure my syntax is wrong somewhere.

thanks,
barb

 

[RoyVidar]

not sure what i am missing
I have a position field that if the word 1st is anywhere in it I want
it to turn red. It is a text data type

I have tried field value is equal to like '*1st*' just '*1st*'
not sure what I am doing wrong??? - not turning red.- and yes I se
the formatting to red??

I am sure my syntax is wrong somewhere.

thanks,
barb

You are using the "Expression Is" option?

And use the name of the field (or control) in [brackets], as in

[MyField] Like "*1st*"

 

[Beetle]

Change the condition from Field Value Is to
Expression Is, then in the criteria box put;

[YourFieldName] Like "*1st*"

 

[babs]

Thanks it works!!!!

Change the condition from Field Value Is to
Expression Is, then in the criteria box put;

[YourFieldName] Like "*1st*"

--
_________

Sean Bailey

not sure what i am missing
I have a position field that if the word 1st is anywhere in it I want it to
turn red. It is a text data type

I have tried field value is equal to like '*1st*' just '*1st*' not sure
what I am doing wrong??? - not turning red.- and yes I se the formatting to
red??

I am sure my syntax is wrong somewhere.

thanks,
barb