hide zero values in Access 97 report

[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

 

[fredg]

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

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.

 

[CHW]

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

Did I do something wrong?

Thanks for the help.

CHW

 

[fredg]

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

Did I do something wrong?

Thanks for the help.

CHW

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;""

 

[CHW]

Thank you for the help.

It works.

CHW

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;""