Can I suppress page header in report footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a report which itemises product sold. On the last page (report
footer) I have a report summary which totals various groups designed for a
top level management report as they have no interest in detail.

What I need to do is suppress the page header in the report footer as it
bears no relation the the layout of the page. I'm sure I saw something about
this a few months ago but can't find it now so any help would be appreciated.

Thanks

Sheila
 
Hi

I have a report which itemises product sold. On the last page (report
footer) I have a report summary which totals various groups designed for a
top level management report as they have no interest in detail.

What I need to do is suppress the page header in the report footer as it
bears no relation the the layout of the page. I'm sure I saw something about
this a few months ago but can't find it now so any help would be appreciated.

Thanks

Sheila
Click to expand...

Reports have a PageHeader property (it's on the Report Property
sheet's Format Tab.
Set it to Not with Rpt Ftr
 
Sheila said:
I have a report which itemises product sold. On the last page (report
footer) I have a report summary which totals various groups designed for a
top level management report as they have no interest in detail.

What I need to do is suppress the page header in the report footer as it
bears no relation the the layout of the page. I'm sure I saw something about
this a few months ago but can't find it now so any help would be appreciated.
Click to expand...


Add a line of code to the page header's Format event
procedure:
Cancel = (Me.Page = Me.Pages)

If you don't already have one, add a text box (anywhere)
that references the Pages property. A common way is to use:
=Page & " of " & Pages
 
fredg said:
Reports have a PageHeader property (it's on the Report Property
sheet's Format Tab.
Set it to Not with Rpt Ftr
Click to expand...


Muuuch nicer that my answer, Fred.

I guess I'm stuck on the older way of doing things :-(
 
Back
Top