Null display if value is $0.00?

  • Thread starter Thread starter Slez via AccessMonster.com
  • Start date Start date
S

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
 
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?
Click to expand...
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 <--
 
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
Click to expand...

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

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