Form field sum doesn't display zero

[engelwood]

I have a very simple form based on a table. I've created a sum total in the form header to sum the individual columns. (E.G. sum(MTH01), sum(MTH02)) The sum works fine, but when the column totals zero the field does not display the zero. The field will remain blank unless you click on the field, then it displays zero. In case I have some null values I've tried NZ in various formats, but it doesn't seem to make a difference. Does anyone have an indication of what I might be missing?

 

[engelwood]

Ah, I figured it out. It was my formatting (#,###). Removing that fixed the issue.