Report footer - not on page one if more than one page of output

  • Thread starter Thread starter Larry Kahm
  • Start date Start date
L

Larry Kahm

I am stumped - and it's probably an easy solution.

I've designed a report that should, in most cases, fit on one side of the
page. If that's the case, the page footer should print on the bottom of the
page.

However, in some cases, there will be data that runs on to page two. In
those cases, I can't have the footer appear on the first page - it must
appear on page two.

What should I be coding - and where? No matter what I've tried, it doesn't
seem to work.

Thanks!

Larry
 
Beware that there are Page Footer which appears at the bottom each page and
the Report Footer which appears on the last page only.

In your post, the subject says "Report footer" but the body of the post says
"page footer"??? Perhaps, you accidentally use the wrong footer in the
design of your Report?
 
I am stumped - and it's probably an easy solution.

I've designed a report that should, in most cases, fit on one side of the
page. If that's the case, the page footer should print on the bottom of the
page.

However, in some cases, there will be data that runs on to page two. In
those cases, I can't have the footer appear on the first page - it must
appear on page two.

What should I be coding - and where? No matter what I've tried, it doesn't
seem to work.

Thanks!

Larry
Click to expand...

Make sure you have a control in the report to compute Pages, i.e.
=[Pages] or = "Page " & [Page] & " of " & [Pages]

Then code the PageFooter Format event:

If Me.[Pages] > 1 Then
Cancel = Me.Page = 1
End If
 
Ah! and I >know< that...

Thanks!

Larry

Van T. Dinh said:
Beware that there are Page Footer which appears at the bottom each page
and the Report Footer which appears on the last page only.

In your post, the subject says "Report footer" but the body of the post
says "page footer"??? Perhaps, you accidentally use the wrong footer in
the design of your Report?
Click to expand...
 
If the use of Report footer doesn't fix the problem, I am sure this will.

Thanks!

Larry

fredg said:
I am stumped - and it's probably an easy solution.

I've designed a report that should, in most cases, fit on one side of the
page. If that's the case, the page footer should print on the bottom of
the
page.

However, in some cases, there will be data that runs on to page two. In
those cases, I can't have the footer appear on the first page - it must
appear on page two.

What should I be coding - and where? No matter what I've tried, it
doesn't
seem to work.

Thanks!

Larry
Click to expand...

Make sure you have a control in the report to compute Pages, i.e.
=[Pages] or = "Page " & [Page] & " of " & [Pages]

Then code the PageFooter Format event:

If Me.[Pages] > 1 Then
Cancel = Me.Page = 1
End If
Click to expand...
 
Back
Top