Access report-suppress 0 records

[ranebow]

I have a table that may have zero in one of the fields. I'd like to NOT print this record on the reports.

 

[CosmoKramer]

In the On Format event of your report's detail section, put code like this:

If Me.YourZeroField = 0 Then
   Cancel = True
End If

If that control = 0, then the detail line will not print.

 

[ranebow]

I must be doing something wrong. I right click on the DETAIL header on my report and pulled up properties. Then in ON FORMAT I created the following EVENT:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.PurchasePrice = 0 Then
Cancel = Ture
End If
End Sub

When I run the report the records with a zero purchase price still show up.

 

[CosmoKramer]

Is PurchasePrice the name of the text box, and not its control source??

Is

Cancel = Ture

just a typo from putting the code here??

 

[ranebow]

It was a typo in the event!!!! Thank you. It works fine!