grouping levels - Sorting & Grouping in Microsoft Access Reports


	Back to Grouping Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

grouping levels

Ludwig Willems

2 years ago

Is it possible at report level if there is already grouping to indicate that per page max division 4 details subdivisions or less if the number per grouping does not reach 4 divisions.. see attachment. Hopefully my explanation is a bit clear.

	Ludwig Willems OP @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
Ludwig sorry my friend. try and explain this again.

	Adam Schwanz @Reply 2 years ago
Are you asking if you can make it only show 4 items per page max?

	Ludwig Willems OP @Reply 2 years ago
indeed Adam, max 4 details (items) per page

Adam Schwanz @Reply

2 years ago

Here's from chat GPT, that should get you in the right direction. This is the on print event from the detail section of the report

Add a PageBreak control to the form.

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

    Static itemCount As Integer

    itemCount = itemCount + 1



    If itemCount Mod 4 = 0 Then

        Me.NextRecord = False

        Me.PageBreak.Visible = True

    Else

        Me.PageBreak.Visible = False

    End If



    If itemCount Mod 4 = 0 Then

        Me.PageBreak.Visible = True

    End If



    If itemCount Mod 4 = 0 Then

        itemCount = 0

    End If

End Sub

	Ludwig Willems OP @Reply 2 years ago
ok thank you i will check it out

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Grouping.

Next Unseen

New Feature: Comment Live View