Conditional page breaks

message from John on 25 May 2004
Hi

Is it possible to give conditional page breaks in access reports depending
on a field value?

Thanks

Regards
 
Arvin Meyer replied to John on 25 May 2004
Set the PageBreak to Visible or not in the Detail section's On Print event.
This is only available in code:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If Me.TestName = "Test2" Then
Me.PageBreak1.Visible = True
Else
Me.PageBreak1.Visible = False
End If

End Sub
 

Archived message: Conditional page breaks (MS Access Forms)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.