Can I use formatting inside of an IIF statement in a report?
For instance:
=IIf(xyz > 1000, "This is large", "This is small")
Can I have the word This underlined and bold, and the word large in bold, or the word small in italics?
Thank you
Can I use formatting inside of an IIF statement in a report?
For instance:
=IIf(xyz > 1000, "This is large", "This is small")
Can I have the word This underlined and bold, and the word large in bold, or the word small in italics?
Thank you
Yes. The text format would have to be set to Rich Text and you'd use HTML inside the string.
Thank you, by HTML, would I do bold like this?Code:<B> </B>
Yes, I tested:
=IIf(1=1,"<b><u>this</u></b> is bold","not")
Happy to help!