changing the header of a group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a report with a few group headers, which are repeated on each and
every page of the report. However, I want the header to change if it
re-appears on a new page after it appeared previously. if the header was
something like:
Sales for [year]:
I want it now to be something like:
Sales for [year] - continued:

Is there a way to do that (either using access or VB)?
Thanks
 
dshemesh said:
I have a report with a few group headers, which are repeated on each and
every page of the report. However, I want the header to change if it
re-appears on a new page after it appeared previously. if the header was
something like:
Sales for [year]:
I want it now to be something like:
Sales for [year] - continued:
Click to expand...


Add a text box named txt<some group id>Cnt (e.g.txtSalesCnt)
to the next lower level header (or detail if at the lowest
group level). Set it's control source expression to =1 and
RunningSum property to Over Group.

Now add a label named lblCont to the group header section.
position it right after the label and set caption to
(continued). Then add a line of code to the group header
section's Format event to make the label visible or not:

Me.lblCont.Visible = (Me.txtSalesCnt > 1)
 
Back
Top