Suppressing Zeroes

  • Thread starter Thread starter Zeroed
  • Start date Start date
Z

Zeroed

I have a number of zeroes in my query and therefore my
reports are really tough to read through.

0 was set as the default value in the tables but I'm sure
there is a way to suppress them for the reports. I have
tried an IIF statement with no luck.

Any suggestions?
Thanks
 
I have a number of zeroes in my query and therefore my
reports are really tough to read through.

0 was set as the default value in the tables but I'm sure
there is a way to suppress them for the reports. I have
tried an IIF statement with no luck.

Any suggestions?
Thanks
Click to expand...

In the report, set the Control's Format property to:
#;-#;""

See Access Help on
Format property + Number and Currency datatype
 
Wicked, thanks
-----Original Message-----


In the report, set the Control's Format property to:
#;-#;""

See Access Help on
Format property + Number and Currency datatype
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top