Forced New Page In Access Report

[plengeb]

I have an access report where I need to force a new page after a section is finished. However, after the last record is printed, that section forces a final, blank page. Does anyone know of a way to prevent the last forced page if it has encountered the final record? Thank you.

[RayMilhon]

Yes there is but I haven't used it in a while. Don't remember the exact steps but you have to declare a variable to count the pages in the format event (I believe it's in the detail section but not sure. Then in the print event of the report footer Or the first group footer check the variable against the total pages if they are = then set new page = false. I'll try and find the db I used that in and post the code here later.

[plengeb]

Thanks Ray. I do appreciate it.

[plengeb]

I figured out how to renumber the pages as desired. I believe the approach to prevent the page from printing is: If me.page = me.pages then do not print the page, but I still don't know the correct syntax.

[boblarson]

I figured out how to renumber the pages as desired. I believe the approach to prevent the page from printing is: If me.page = me.pages then do not print the page, but I still don't know the correct syntax.

In the Section's On Format event put:

    If [Page] = [Pages] Then
        Me.GroupFooter0.ForceNewPage = 0
    End If

Change GroupFooter0 to the actual name of your section.

[plengeb]

Thanks Bob. That did the trick.