Conditional page breaks

[John]

Hi

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

Thanks

Regards

 

[Arvin Meyer]

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

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
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access