troubleshooting Question

Limiting Access Report Detail Sections to a Specific Number per Page

Avatar of fostermom45
fostermom45 asked on
Microsoft Access
11 Comments1 Solution305 ViewsLast Modified:
I need to limit my details on each page of my report with out losing my Group footer.  When I used the suggested solution that was out there.
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    If txtrowcount Mod 14 = 0 Then
        Detail.ForceNewPage = 2   ' after section
        Detail.ForceNewPage = 0   ' none
    End If
End Sub

Using the running sum property and the textbox =1.  It worked for the details but I lost my sum that was in the Group footer.  I then tried putting my Sum in the page footer (the page footer still shows up) but the Sum in the page footer does not work.    Do you have any suggestions?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros