Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Footers (Access 97 SR2)

    Is there a way to force a rReport Footer to the bottom of the page. When the report has finished being produced the Report Footer is hlfway up the last page under the last piece of data. I would like it to appear at the bottom of the last page.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Footers (Access 97 SR2)

    The only footer that prints at the bottom of the page is the page footer. It might be possible to hijack that on the last page of the report and show the results from the report footer in it, though, while hiding the report footer itself.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Footers (Access 97 SR2)

    This may work but that would make it display on every page then wouldn't it?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Footers (Access 97 SR2)

    No, you would use code to make the controls visible in the page footer on the last page, and you would populate them from the values calculated for your report footer. You could use a test for If [Page] = [Pages] to determine it was the last page.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Footers (Access 97 SR2)

    Thanks. I will give it a try but my coding is very rusty. You may hear from me again soon. <img src=/S/grin.gif border=0 alt=grin width=15 height=15> <img src=/S/dragon.gif border=0 alt=dragon width=17 height=15>

  6. #6
    Star Lounger
    Join Date
    Jan 2001
    Location
    Yorkshire, England
    Posts
    82
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Footers (Access 97 SR2)

    There is a method of moving the report footer down the page discussed by Helen Feddema in Woodys Access Watch 4.01 or on Helen's site as her Access Archon column #97

  7. #7
    New Lounger
    Join Date
    Jun 2002
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Footers (Access 97 SR2)

    About to give it a go. Thank you

Posting Permissions

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