Access Reports Omit Group Headers 1

[rschneeg]

I have 3 levels of group headers in my report. How do I eliminate printing them if there is no data for these levels?

 

[THWatson]

rschneeg
You can put code on the Group Header

If IsNull(YourTextBoxInTheHeader) Then
Me.YourTextBoxInTheHeader.Visible = False
Else
Me.YourTextBoxInTheHeader.Visible = True
End If

Tom

 

[THWatson]

The other thing you could do would be to put code on the Activate event for the report.

Private Sub Report_Activate()
If IsNull(YourTextBoxInHeader) Then
Me.YourGroupHeader.Visible = False
Else
Me.YourGroupHeader.Visible = True
End If
End Sub

Tom

 

[rschneeg]

I tried a little of each and got it to work on multiple levels of group headers.
Thanks!