Format - show blank if zero

[LiamP]

I have a simple integer field that may be zero or some positive integer.

I use Format(iActive, “##,###”) to assign to a textfield on a form.

If iActive is zero, it prints 0. If it is zero I want it to print a blank (or not print anything).

Obviously I can test the textfield afterward and compare to “0” and replace with a blank, but is there not a more straight forward way to do this?

thanks

[Tim_Parnell]

The formatSpec can be made up of up to three formats separated by semicolons. The first format is the format to be used for positive numbers. The second format is the format to be used for negative numbers and the third format is the format to be used for zero.

Just an untested guess, but from reading this, what about the format ##,###;-##,###;(using a second semicolon, but intentionally leaving the zero value empty).

[LiamP]

I don’t see the second format spec in the docs. At least when I click the big question mark at the top of the Xojo window. Where do I find this?

[Tim_Parnell]

http://documentation.xojo.com/index.php/Format

[LiamP]

Okay, I see it. It’s just in the format at the top of the page it just shows one set.

Thanks Tim,

b