Print 'continued' on the first page

M

Marilyn

If there are more than one page of a report, how do I print for example,
"Cost Summary Continued on next page" on the first page?
Also, I have a line to separate two sections on the report, when there is a
second page, I want to make this line invisible on the first page.

I appreciate any suggestions.

Thank you.
 
M

Marshall Barton

Marilyn said:
If there are more than one page of a report, how do I print for example,
"Cost Summary Continued on next page" on the first page?
Also, I have a line to separate two sections on the report, when there is a
second page, I want to make this line invisible on the first page.
Click to expand...

Use a text box with the expression:

=IIf(Page<>Pages,"Cost Summary Continued on next page","")


I don't understand your second question. Could you explain
it in more detail?
 
T

Terry

Marilyn,

Put a text box in your page footer with something like:

=IIF ([pages]>[page],"Cost summary continued on next
page","")

You may find your report takes a bit longer to format as
it needs to format all pages to get a value for [pages].

HTH,

Terry
 
Top