I used to capture results in an conditional statement to clean up reports. It is still useful, when you want hide conditional statements. =IIf(<expr> = 0, "", <expr> ) However, I was considering the option numeric values have, to hide 0 values. Which is: 0;(0);'' Now to hide the percentage format, use this: 0.0%;(0.0%);''
Looking to the world of Microsoft Dynamics CRM, Dynamics NAV, Scribe Insight, SCCM, and other server applications.