Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Continuation Sheet (A2K SR1)

    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.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Report Continuation Sheet (A2K SR1)

    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
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Frederick, Maryland, USA
    Posts
    296
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Continuation Sheet (A2K SR1)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •