no page break on last page but one

[Michel Peeters]

I use following code in the on format event from the section which contains
the pagebreak. It cancels the pagebreak on the last page but one:

If Me.Pages - Me.Page = 1 Then Me.PageBreak1.Visible = False

This works fine except "Pages" shows one page more as my report.
How can I avoid this?

Michel

 

[Ken Snell]

Use [Pages] - 1 as the expression for the total number of pages?