Thank you for your response. However, it does not work.
The report is 3 pages long, with several subreports. Presently only one of
the reports spans from page 1 to page 2. I enabled the report footer for the
subreport and used the text box with the formula.
The words "Last Page" appeared at the end of the subreport, but "Continued
on next page" did not appear on the 1st page - which is on the 1st page of
the main report.
If the subreport was, itself, a main report, then it would only be 1 page.
The main report does have page and report footers, so perhaps that is the
problem?
The page numbers for the main report appear in the report page footer.
I put the text box on the main report footer, and it worked for the main
report, with each page showing "Continued....", and "Last Page" on the last
page.
The total report is 4 pages.
I tried enabling page numbers for the subreport, and using a report footer,
but it did not produce the desired results.
Any other idea, or suggestion, would be greatfully appreciated.
Thanks,
Al
hmadyson said:
Create a textbox on the footer of the subreport. In the ControlSource put a
similar formula:
=IIf([Page]<>[Pages],"Continued on Next Page","Last Page")
This will say Continued on Next page if it is not the last page or Last
Page. You can change the wording to what you would like.
Please let me know if I can provide more assistance.
Al Smith said:
First, thank you for the suggestions I've found here for subreport page
headers and grouping.
Now that I have mastered that part, I would like to have a "continuation
footer" for a subreport - "Continued on Next Page", etc.
Is there a way to do this?
Thanks in advance,
Al
