Group header to show "Group Cont'd"

  • Thread starter Thread starter Eric Blitzer
  • Start date Start date
E

Eric Blitzer

I have a report that has a group header. If the group has
so may records that it takes up two pages I would like the
page header(on the following page) to show "Group cont'd".
Can anyone help me?

Thanks

Eric
 
Eric said:
I have a report that has a group header. If the group has
so may records that it takes up two pages I would like the
page header(on the following page) to show "Group cont'd".
Click to expand...


Add a text box named txtLineCnt to the detail section. Set
its control source expression to =1 and RunningSum property
to Over Group.

Now you can add a little code to the the page header's
Format event to make your continued label visible or not:

Me.lblContinued.Visible = (Me.txtLineCnt > 1)
 
Sweet!

--
Duane Hookom
MS Access MVP
--

Marshall Barton said:
Add a text box named txtLineCnt to the detail section. Set
its control source expression to =1 and RunningSum property
to Over Group.

Now you can add a little code to the the page header's
Format event to make your continued label visible or not:

Me.lblContinued.Visible = (Me.txtLineCnt > 1)
Click to expand...
 
Back
Top