Conditional printing in Access

[MIchel Khennafi]

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

 

[Douglas J. Steele]

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