I have a report consisting of multiple clients. I want my letter head to appear only on the first page of each client Group.
My problem is the Group Header follows the Page Header so the Page Headings for the Detail line are before my Letter Head in my Client Group Header.
Suggestions?
BTW I can get the letterhead to not show by setting the label.visible to FALSE but that causes a large gap at the top of the page.
Code:
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If LastClient = ClientName Then
Label26.ForeColor = vbWhite
OLEUnbound78.Visible = False
Else
Label26.ForeColor = 8388608
OLEUnbound78.Visible = True
LastClient = ClientName
End If
End Sub