F fredg Jan 20, 2004 #2 How would I have $0.00 values NOT show up in a report? Click to expand... Several ways. Here's one: Set the Format property to the control to: $#,##0.00;-$#,##0.00; Only positive or negative amounts will show, with a comma thousands separator and the $ sign. See Access help on the Format property.
How would I have $0.00 values NOT show up in a report? Click to expand... Several ways. Here's one: Set the Format property to the control to: $#,##0.00;-$#,##0.00; Only positive or negative amounts will show, with a comma thousands separator and the $ sign. See Access help on the Format property.