Not Print Report Footer

  • Thread starter Thread starter AHopper
  • Start date Start date
A

AHopper

I want to place the following criteria in the On Print
event of a Report Footer and have the Footer not print.
How do I stop the Foote from printing?

If Nz([Forms]![SixDifinSkidReportDialog]![FirstNumber]) <
1 Then

Exit Sub
End If

Thanks for your help

Allan
 
I want to place the following criteria in the On Print
event of a Report Footer and have the Footer not print.
How do I stop the Foote from printing?

If Nz([Forms]![SixDifinSkidReportDialog]![FirstNumber]) <
1 Then

Exit Sub
End If

Thanks for your help

Allan
Click to expand...

Place the code in the Report Footer Format event:

If Nz([Forms]![SixDifinSkidReportDialog]![FirstNumber]) < 1 Then
Cancel = True
End If
Exit Sub

The form must be open when this code is run.
 
Fred
Thank you very much.
Allan
-----Original Message-----
I want to place the following criteria in the On Print
event of a Report Footer and have the Footer not print.
How do I stop the Foote from printing?

If Nz([Forms]![SixDifinSkidReportDialog]![FirstNumber]) <
1 Then

Exit Sub
End If

Thanks for your help

Allan
Click to expand...

Place the code in the Report Footer Format event:

If Nz([Forms]![SixDifinSkidReportDialog]![FirstNumber]) < 1 Then
Cancel = True
End If
Exit Sub

The form must be open when this code is run.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top