Showing fields that are zero in report

[Damon Grieves]

Hi
I have 12 fields that I want to print on a report but the field is not to be
printed if it is equal to zero.
Using On Print I can not shown groups but it is possible to do individual
fields?
The queries involved to lose the zero fields would be fairly complex and it
would be a lot easier just to do it on the report.
TIA

[Phil Stanton]

Assuming the controls are on the detail section of the report, you need an
event procedure for the OnFormat something like
Field1.Visible = Nz(Field1)
Field2.Visible = Nz(Field2)
etc
If Field1 is zero then the visible property is set to false, otherwise it is
set to true

HTH

Phil
"Damon Grieves" <da****@vfeNOSPAMmail.net> wrote in message
news:42***********************@news.optusnet.com.a u...

Hi
I have 12 fields that I want to print on a report but the field is not to
be
printed if it is equal to zero.
Using On Print I can not shown groups but it is possible to do individual
fields?
The queries involved to lose the zero fields would be fairly complex and
it
would be a lot easier just to do it on the report.
TIA

[Gord]

Or, you could set the Format property of the controls to something like

#,##0;(#,##0);"";"Null"

The third section is the one that is applied when the value is zero.
See the help topic "Format Property - Number and Currency Data Types"
for more information.