Hi, is there an easy way to do a conditional format on a report where the value is 1,2,3,or 4 from an option group. I want the 1=Yes, 2=No, 3=Maybe etc.
Thanks.
Fen
Typically I'd have those values in a table, and join that table in the report's source query. If you don't want to do that, you can use the Switch() function or nested IIf() functions.
