Hiding Zero Values

[kristyspdx]

Hello,

I have rows in a report like this:

Center	Name	Beg Bal	Results	Operations	Loan	Other	Ending Bal
1-97-xxx-xxxx	Chemistry Dept	1,000.00	(630.00)	0.00	0.00	(370.00)	0.00

I would like to supress the entire row, when printed, if the ending balance is zero, even if the other numbers are not zero. The "On Format" box is not displayed as an option in the Property Sheet, I guess because this is detail information, not a header. I have used code in the On Format box to hide other parts of this report (example below), but not sure if it can be done for rows like above. Ideas?

Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.Division_Subgroup1) Then
Cancel = True
End If
End Sub

[June7]

The ending balance is calculated on report, not a field in query?

Detail section does have Format event but I don't think it will help.

I don't know if code can suppress a record. I've only use filter criteria to exclude records from report.

[NTC]

well I 'zeroed' in on your comment of: "when printed"

copy/make a separate Report object for printing only; give it its own query/record source that is a variation from the one that is viewed - whereby there is a >0 criteria - so that this record source does not have those records..... then view 1 Report but print the other Report.