Dynamically Change TextColor of Formula

[Jefftopia]

I have a formula which resides in a subreport. The results of this formula are either "Pass" or "Fail". I would like the textcolor for the result to be displayed in green for "Pass" and red for "Fail".

Anyone ever done something like this before. Not sure if I should be attempting to change the color in the Initialize event procedure of my main report or handling directly in the formula itself.

 

[synapsevampire]

Right click the field and select Borders and Colors->Font->X-2 next to the color and place something like:

If {@MyFormula} = "pass" then
crgreen
else
crred

-k

 

[Jefftopia]

Thanks synapsevampire. That was the ticket.