Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Suppress a Text Object (%) when field is null
- Thread starter pgmr
- Start date
A % is actually a variation of a currency format. To Change a currency format, right click the object, format, number, customize, currency symbol.
Make the currency symbol a trailing rather than leading symbol, and blank out the $ from the currency symbol field, as we are going to enter a formula to determine the currency sysbol.
Conditional Format the currency symbol by clicking on the X-2 field to the right of teh currency symbol field, an enter the formula:
if {fieldname}=0 then "" else "%".
You're done!
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
Make the currency symbol a trailing rather than leading symbol, and blank out the $ from the currency symbol field, as we are going to enter a formula to determine the currency sysbol.
Conditional Format the currency symbol by clicking on the X-2 field to the right of teh currency symbol field, an enter the formula:
if {fieldname}=0 then "" else "%".
You're done!
Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Question
- Locked
- Question