Access Reports: leave blank instead of printing zeros

[ximedo]

I am a active user of Access, and print frequent reports will many numbers,
among which mostly "zeros". Would love to be able not to print "zeros", since
they affect the visual image of the Report. Instead of printing a zero, would
like to have a blank space. Like in excel spreadsheets, Tools/Options/Zero
values clean spreadsheet of zeros ... thanks your help

 

[Allen Browne]

You can set the Format property of the text box to show nothing for zero.

For example:
$#,##0.00;($#,##0.00)[Red];""

The Format consists of up to 4 parts:
- positive
- negative
- zero
- null

 

[John Spencer]

You can use the format property of the controls to force zeroes to print as
blanks
Or you can change the zeroes to nulls in the underlying query.

In a query:
Field: SomeFieldZ: IIF(SomeField = 0, Null, SomeField)

Format Property of Control
Format: #;-#;"";""

Print the number if it is positive or negative. Print a zero length string
if the number is zero or null

If you want further formatting on the number, press the help (F1 key) when
you are in the format property for the control.