Need to suppress the last page of a report

[Super Wife Mom]

I have a report which forces a new page each time the section footer is
printed, but I need to suppress the final page because it is always blank.
Is there any way of doing this?

 

[Marshall Barton]

I have a report which forces a new page each time the section footer is
printed, but I need to suppress the final page because it is always blank.
Is there any way of doing this?

If you have set the group footer section's ForceNewPage
property to After Section, try setting the group header
section's ForceNewPage proeprty to Before Section instead.

If that interferes with the report header, then add a
PageBreak control *named pgEject) to the top of the group
header section and add a line of code to the group header
section's Format event procedure:

Me.pgEject.Visible = (Me.Page > 1)

 

[Super Wife Mom]

Dear Marshall,

Thanks for this. It worked perfectly!

Regards,
Super Wife Mom