Report Footer

[bijondhanbad]

How do I print a different page footer on different pages? Pl help.

 

[Brianwarnock]

Use a case select to select the value of a text box based on the page number.

eg a text box text1 exists in the page footer.

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Select Case me.page
Case 1
Me.Text1 = "hey"
Case 2
Me.Text1 = "hello"
Case Else
End Select

End Sub

 

[bijondhanbad]

Thanks Brian. It has worked.
Can u help me out with another footer/header problem?

I want to have different footers in different copies of the same page. Like while printing an invoice, I want CUSTOMER COPY on one copy, SELLER COPY on the second copy, OFFICE COPY on the third copy of the invoice.

 

[Brianwarnock]

I have never worked with this scenario, I assume that these invoices are not printed using preprinted mulyipart staionary but are printed one after the other with no page numbers.

define pagecheck in a code module as
Public pagecheck as integer

In the reports load event
pagecheck = 1

in the PageFooterSection_Format use a select case

select case pagecheck
case 1
me.text1 = "Customer Copy"
pagecheck =pagecheck+1
case 2
me.text ....
pagecheck=pagecheck+1
case 3
me.text....
pagecheck=1
end select

Think that should work

Brian