Page Header problem

  • Thread starter Thread starter Ahmad Beshari
  • Start date Start date
A

Ahmad Beshari

Dears
i have report with one group level i like to hide the
page header if the group footer is printed so they will
not be printed in the same page(the group footer will be
printed in separat page)
thanks
 
Ahmad said:
i have report with one group level i like to hide the
page header if the group footer is printed so they will
not be printed in the same page(the group footer will be
printed in separat page)
Click to expand...


SInce no one else has provided an answer, I'll take a shot
at it.

First create a detail counting text box in the details
setction. Name it txtDetailNum, set its ControlSource
expression to =1 and RunningSum property to Over Group.

Next add a text box in the group header section with the
total details in the group. Name this one txtDetailCount
and its ControlSource expression to =Count(*)

Then add code to the detail section's Format event to make
the page header invisible when you're on the last detail in
a group:

If Me.txtDetailNum = Me.txtDetailCount Then
Me.Section(4).Visible = False
End If

Also add a line of code to the group footer's Format event
to make the page header visible for the next group:

Me.Section(4).Visible = True
 
Back
Top