Change Text Color on a Form if Text is "SAD"

[rxm01l]

Folks..

I have a Form Display Data in my Access Database, which is working really well. However, users was asking if there is a way we can make Font Color Could/would change if The text in A field or Any field in my display form contained the word "SAD or MAD". Is there code for such thing in display form?.. Please Advise..

Thanks in Advance.. This would help users alot especially when the browse through so many datas each day..

 

[Mihail]

Use conditional formatting.

 

[rxm01l]

Hi Mihail, I just noticed that.. can conditional formating do work with two Words. Example, if there SAD and MAD in the column, would format both words? Thanks So much for a quick responsed..

 

[Mihail]

Should work. Just add more conditions.