Field does not show zero despite option unchecked in inspector

[MSPJ]

Hi - I have several fields that I want to show zero if the value is zero (rather than be blank). Some are calculated fields and some are user editable. On the data tab of the inspector, I have left UNCHECKED the option Do not display number if zero.  Yet, they remain blank if zero.  The fields are formatted as currency with fixed decimal set to 2.

Is there some simple option I'm missing?

[David Jondreau]

Zero and "blank" are different things. The field formatting checkbox displays the number even if it's zero. That's different than "displaying zero if the value is blank".

Your fields need to contain the number zero if you want zero to be displayed. Change your calculations so they return zero. Give your number fields a default value of zero.

[MSPJ]

Thanks David - that fixed it!