Null display if value is $0.00?

[Slez via AccessMonster.com]

I have a report with multiple rows and columns which takes on sort of a
spredsheet appearance. Is there a way to have fields where the value is $0.
00 (currency format) appear as if they're blank? All those 0's tends to make
the report a bit cluttered.

Thanks!
Slez

 

[Stefan Hoffmann]

hi,

I have a report with multiple rows and columns which takes on sort of a
spredsheet appearance. Is there a way to have fields where the value is $0.
00 (currency format) appear as if they're blank?

If your report can handle it, modify the record source:

MoneyNull: Iif([Money]=0;Null;[Money])

Or do it in the TextBox on the report:

=Iif([Money]=0;Null;[Money])


mfG
--> stefan <--

 

[fredg]

I have a report with multiple rows and columns which takes on sort of a
spredsheet appearance. Is there a way to have fields where the value is $0.
00 (currency format) appear as if they're blank? All those 0's tends to make
the report a bit cluttered.

Thanks!
Slez

Sure.
Set the control's Format property to:
#;-#;

See Access help on the
Format property + Number and currency datatypes