"Continued from previous page" on a grouped report

  • Thread starter Thread starter Gary J. Jahnke
  • Start date Start date
G

Gary J. Jahnke

I have a grouped report, set up to print the title of the group on each page
(the group's name is in the page header). It is also set to start a new page
for each group. It works great. However, some groups stretch to a second
page - which is fine. What I would like is to have the report automatically
add the phrase "Continued from previous page" or something similar to the
group's name on the second page where there is one. Not all groups require
two pages.
 
Use the control that counts your group pages to show or hide a text box that
contains the phrase

="Continued from Previous Footer" if the Group Page Number is >1

eg

If Me.[YourGroupPageNumber]>1 Then
Me.[txtContinued].Visible=True
Else
Me.[txtContinued].Visible = False
End If

combine this with your code for counting the group pages

Evi

In the On Format of the page footerevent include the lines
 
Thank you so much, Marshall! Your solution worked perfectly.

Marshall Barton said:
I have a grouped report, set up to print the title of the group on each page
(the group's name is in the page header). It is also set to start a new page
for each group. It works great. However, some groups stretch to a second
page - which is fine. What I would like is to have the report automatically
add the phrase "Continued from previous page" or something similar to the
group's name on the second page where there is one. Not all groups require
two pages.
Click to expand...


Add a hidden text box (named txtLine) to the detail section.
Set its ControlSource to =1 and RunningSum to Over Group.

Then the group header section text box can use an expression
like:
=[group name field] & IIf(txtLine>1, " (Continued)", "")
Click to expand...
 
Back
Top