Different last page

[Stephen]

I have an invoice that has a page header and footer for each page of the
invoice. We are looking to have a merchandise return form printed
automatically as the last page of the invoice. However, this last page
should NOT have the same header and footer as the rest of the invoice.

We have tried creating a Merchandise Return form as a subreport and placing
it in the report footer of the Invoice, however this prints the Merchandise
form as a last page, yet it still places the detail inbetween the Invoice
Header and Footer.

We have tried putting the Merchandise Return information directly in the
footer of the Invoice, with a Page Break before this section. However, this
also prints in-between the Invoice Header and Footer on the last page.

Effectively, we want that last page (merchandise Return Form) to have a
slightly different Header and Footer than the rest of the invoice.

Is this possible? How can we do this?

-stephen

 

[Marshall Barton]

I have an invoice that has a page header and footer for each page of the
invoice. We are looking to have a merchandise return form printed
automatically as the last page of the invoice. However, this last page
should NOT have the same header and footer as the rest of the invoice.

We have tried creating a Merchandise Return form as a subreport and placing
it in the report footer of the Invoice, however this prints the Merchandise
form as a last page, yet it still places the detail inbetween the Invoice
Header and Footer.

We have tried putting the Merchandise Return information directly in the
footer of the Invoice, with a Page Break before this section. However, this
also prints in-between the Invoice Header and Footer on the last page.

Effectively, we want that last page (merchandise Return Form) to have a
slightly different Header and Footer than the rest of the invoice.

AXP has the report properties PageHeader and PageFooter that
you can set to Not with Rpt Ftr.

If that doesn't take care of your problem, post back with
more details.

 

[Stephen]

Marshall -
I put the following code in the ReportFooter visual basic code:

Reports!rptInvoice.PageFooter = 2

however, when I open the report, it tells me I can't assign a value to this
object. I read the help section related the Page Footer Propert, but the
instruction doesn't seem to work...

...I am a bit embarassed because I do a lot of Access Development and this
eludes me...

Not With Rpt Ftr 2 The page footer isn't printed on the same page as
the report footer. Microsoft Access prints the report footer on a new page.

The following example sets the PageFooter property for a report to Not With
Rpt Hdr. To run this example, type the following line in the Debug window
for a report named Report1.
Reports!Report1.PageFooter = 1

 

[Marshall Barton]

Try setting the property in the report's property sheet, no
code needed.
--
Marsh
MVP [MS Access]

I put the following code in the ReportFooter visual basic code:

Reports!rptInvoice.PageFooter = 2

however, when I open the report, it tells me I can't assign a value to this
object. I read the help section related the Page Footer Propert, but the
instruction doesn't seem to work...

..I am a bit embarassed because I do a lot of Access Development and this
eludes me...

Not With Rpt Ftr 2 The page footer isn't printed on the same page as
the report footer. Microsoft Access prints the report footer on a new page.

The following example sets the PageFooter property for a report to Not With
Rpt Hdr. To run this example, type the following line in the Debug window
for a report named Report1.
Reports!Report1.PageFooter = 1

 

[Stephen]

Marshall -

This worked perfectly. Thank you.

-Stephen

Try setting the property in the report's property sheet, no
code needed.