Seeking for a ForceNewPage global solution

[José António Silva]

Assuming that ForceNewPage = 2, in a footer section, always produce a blank
page at the end of the report, the unique work around I can imagine is:

1)Assuming ascending order, programmatically get the maximum value of some
field (with no duplicate values) that may appear in the last report footer
section.

2)Save this value in a variable, for example, varIDDocument = 999.

3)Put the following code in the footer format event.
If Me.IDDocument.Value = varIDDocument Then
Me.footer1.ForceNewPage = 0
Else
Me.footer1.ForceNewPage = 2
End If

Despite this works fine, this is not a global solution, because I have to
type specific data dependent code.

Anybody knows a global solution to this????????

José António Silva