Set Conditional Page Break 1

[RDS2]

I have a page break hard coded in a report (always visible.)
The break is in the detail section of the report. Is there a way to set the page break to "not visible" if only "X" lines remain on the page?

 

[Remou]

You can set the page break visible property to False. Can you explain a little more about the lines remaining? Do you mean if there are only X number of lines left to print?

 

[RDS2]

Yes - if there are only say, 20 lines remaining (because some controls can grow) when the page break is encountered then I want to force the page break (i. e. the page break control remains visible.) If there are more lines remaining on the page when the page break marker is encountered I would like to set its property to invisable and let page breaking occur normally.

 

[Remou]

You can check the postion of the print using Report.Top

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If Report.Top > 7000 Then 'Twips
    Me.PageBreakX.Visible = True
Else
    Me.PageBreakX.Visible = False
End If
End Sub