Group Headers Not Repeating in a Report

[kristyspdx]

Hello,

I have a report in which I am using VBA script to hide rows with null values. (See attached). When I add this script, some of my group headers are not repeating at the top of every page of the report even though the "Repeat Section" field in the Format Tab is set to "Yes." If I remove the VBA script, all of my headings repeat at the top of each page as I'd like, but then blank lines, of course, appear for those rows that have null values which is not what I want either. Anyone have an idea on how to fix this?

Thanks.

[boblarson]

See if changing to this works better:

Option Compare Database
 
Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer)
    Me.GroupHeader2.Visible =  (Not IsNull(Me.Division_Supergroup))
End Sub
 
Private Sub GroupHeader3_Format(Cancel As Integer, FormatCount As Integer)
    Me.GroupHeader3.Visible = (Not IsNull(Me.AccessTotalsBalance__Deficit__End1))
End Sub
 
Private Sub GroupHeader4_Format(Cancel As Integer, FormatCount As Integer)
     Me.GroupHeader4.Visible = (Not IsNull(Me.AccessTotalsBalance__Deficit__End))
End Sub
 
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Detail.Visible = (Abs(Me.[Balance (Deficit) End]) >= 1)
End Sub

[kristyspdx]

Same result unfortunately.

[boblarson]

Can you post a copy of your database (with bogus info in it of course)?

[kristyspdx]

Hopefully you can get what you need from this. I had to cut the database down a ton in order to get it small enough to attach.

So the problem is, if you click on the report and click Print Preview, notice pages 1-5 repeat the headings at the top as follows: Award type of "Endowment," Group 1 of "UC Schools"; Group 2 of "College of Arts & Science", "School of Engineering", "Business School", etc. When you get to page 6 in Print Preview the Award type has changed to "Gifts" Group 1 "UC Schools" repeats, but the Group 2s--the names of the various schools do not repeat.

Thanks.