hide zero values in Access 97 report

  • Thread starter Thread starter CHW
  • Start date Start date
C

CHW

How do I hide zero values in a report?

Is it possible to hide zero values for a particular field rather than the
entire report ?

Thanks in advance.

CHW
 
How do I hide zero values in a report?

Is it possible to hide zero values for a particular field rather than the
entire report ?

Thanks in advance.

CHW
Click to expand...

Sure.
In the Control's Format property line, write:
#,-#,Null

See Access help on the
Format Property + Number and Currency datatypes
to learn why this works.
 
I followed your suggestion and my zero currency values display:
-Null

Did I do something wrong?

Thanks for the help.

CHW
 
I followed your suggestion and my zero currency values display:
-Null

Did I do something wrong?

Thanks for the help.

CHW
Click to expand...

Access thought you wanted Null as Text so it placed it within quotes
"Null".

Just change the format property to:
#;-#;""

Note: if you want comma separated thousands and .00, use:
#,###.00;-#,###.00;""
 
Thank you for the help.

It works.

CHW

fredg said:
Access thought you wanted Null as Text so it placed it within quotes
"Null".

Just change the format property to:
#;-#;""

Note: if you want comma separated thousands and .00, use:
#,###.00;-#,###.00;""
Click to expand...
 
Back
Top