Conditional printing in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MIchel Khennafi - 02 Jan 2007 22:58 GMT

Happy New Year to all of you and special thanks to all the Access MVP...

New year: New issue...

I have created a report (mail merge type of report). Everything works just
great ... BUT....
I have added a page footer in the "Page footer" section that is appearing on
every page. My report has 2 pages (Letter + personalized information) and I
have 500 customers. therefore I have 1000 pages.

I would like the footer TO NOT PRINT the footer information on the letter
section of the report. What is the condition I need to set in order to
obtain this result? My report is structured as follows:
- Page 1 is the report header page (1 page for the entire 1000 page report)
- Page 2 is the letter for customer 1
- Page 3 is the detailed info for customer 1
- Page 4 is the letter for customer 2
- Page 5 is the detailed info for customer 2
- ... and so on

Thanks for helping

Reply to this Message

Douglas J. Steele - 02 Jan 2007 23:52 GMT

Try putting code in the PageFooter's Format event to change the visibility
of the footer information on the even pages. Something like:

Private Sub PageFooter_Format(Cancel As Integer, FormatCount As Integer)

Me.txtFooterInfo.Visible = (Int(Me.Page/2) * 2 <> Me.Page)

End Sub

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Happy New Year to all of you and special thanks to all the Access MVP...
>
[quoted text clipped - 18 lines]
>
> Thanks for helping

Reply to this Message