Report Continuation Sheet (A2K SR1)

Topic

New Reply

I’ve designed an Access report to look like our corporate purchase order. The report contains, among other things, a detail section (that contains the purchase order line items) and a page footer. The detail section can contain any number of line items and can, therefore, span numerous pages. However, I would like the page footer to print out only on the first page of multi-page purchase orders. Any ideas? As always, thank you for the help.

Reply | Quote

Replies

In the OnFormat event of the PageFooter, I would examine the value in the page counter; if =1 then set all controls to visible; else set all to invisible.

If Me.PageNo =1 then
‘ set .visible=true for all controls in footer
Else
‘ set .visible=false for all controls in footer
endif

Reply | Quote

Thank you, Mark. I’ll give that a try.

Reply | Quote