Hello All:

I built a report and I am trying to change the color of a wingding font based on a IIf statement. My statement is:

=IIf([Build Status]="Completed","J",IIf([Build Status]="In Process","K",IIf([Built In SCM?]<>Yes,"L")))

What happens is if the Build Status = Completed, In process or Built in SCM? <> Yes, a smily face wingding, a half smile face wingding and a frowning face wingding print, in respective order. It works but I would like a green smiley face, a yellow half smile and a red frowning face. Is this possible?

Thanks,
Tony

** Edited.. The above IIf statement is in the Control Source in an unbound text box.


SOLVED... I figured it out. I right-clicked on the text box and used Conditional Formatting and specified that if the Field Value is equal to "J" (Wingding ALT+074), then change font to specified color, etc.. and the same for Field Value 2 and Field Value 3.