Page Break and 200 records

[ferrisj]

I want to create a page break at everyone 200 records. Is that possible in Access?

 

[Remou]

You could try adding a Page Break and a counter to your report (Control Source : =1, Running Sum : Over All). Then add a little code:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.txtCounter Mod 200 = 0 Then
    Me.PageBreakX.Visible = True
Else
Me.PageBreakX.Visible = False
End If
End Sub

Private Sub Report_Open(Cancel As Integer)
Me.PageBreakX.Visible = False
End Sub

This is very slow to run.

 

[ferrisj]

my control source is a query right now, how qould i implement 2 control sources

 

[Remou]

The suggestion is for a Control Source for a textbox, not a Record Source for a report. As far as I recall, you will find more information on Running Sum in Help.