Skip header if no data in detail

[epoh]

I am trying to create a report that will skip the header, if there is no data in the detail section.

I've looked and haven't found anything yet.

 

[dhookom]

You can try add a control to the Group Header section:
[tt][blue]
Name: txtCountGroup
Control Source: =Count(*)
Visible: No
[/blue][/tt]
Then add code to the On Format of the section like:

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = Me.txtCountGroup = 0
End Sub

Duane
Hook'D on Access
MS Access MVP