FM11 - Text values in another field changes this field's text color

[Tony Martin]

Hi everyone.  This one's simple I'm sure.

 

I have a text field where my client can type freely, but most commonly uses two key phrases (PAA and DRM).

 

In another field, I need to format the text color to red when either of these phrases exist in the other field.  The imoprtant thing to remember is that the other field may contain a lot of other text.

 

Brain not working this am (coffee maker broken).  Any ideas?

 

Thank you!

 

Tony

[MartieH]

PatternCount(yourfield,"PAA") = 1

PatternCount(yourfield,"DRM")=1

 

check both for conditional formatting.

 

I think that will work,

Martie

[eos]

Actually, for the CF formula simply use

PatternCount ( textField ; "PAA" ) or PatternCount ( textField ; "DRM" )

[MartieH]

too true....