jackadamson
New member
- Local time
- Today, 16:34
- Joined
- Jul 18, 2011
- Messages
- 7
Hi there,
I am trying to put a page break/set the number of records per page for my report.
I have two group headings (a and b) and the details section.
I would like the page break to occur after there has been 2 records in the "group heading b" and for those records of "group headings of b", all of the details sections are complete.
i.e. In the diagram attached, where the green arrow is. I have also included a diagram for the design view too.
I have tried using this formula below with a text box in "group heading b". However when it creates the pagebreak, only one of the records occurs in the details section (not all 4).
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [txtcounter] Mod 2 = 0 Then
Me.Detail.ForceNewPage = 2
Else
Me.Detail.ForceNewPage = 0
End If
End Sub
Can anyone help?
I am trying to put a page break/set the number of records per page for my report.
I have two group headings (a and b) and the details section.
I would like the page break to occur after there has been 2 records in the "group heading b" and for those records of "group headings of b", all of the details sections are complete.
i.e. In the diagram attached, where the green arrow is. I have also included a diagram for the design view too.
I have tried using this formula below with a text box in "group heading b". However when it creates the pagebreak, only one of the records occurs in the details section (not all 4).
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If [txtcounter] Mod 2 = 0 Then
Me.Detail.ForceNewPage = 2
Else
Me.Detail.ForceNewPage = 0
End If
End Sub
Can anyone help?
