Results 1 to 3 of 3
  1. #1
    chaver's Avatar
    chaver is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2016
    Location
    Kingston upon Hull, England
    Posts
    1

    Page Footer on first page only with no footer on subsequent pages

    I am developing a large report that requires a Report Header and Page Footer to only appear on the first page.

    The page footer contains a large picture of various Logos showing membership of various associations but only needs to appear on the first page.

    The text on the first page varies in depth between reports so I cannot use a fixed position on the first page for the Logo picture.

    In the OnPrint on the Page Footer I have used the code:

    Me.PageFooterSection.Visible = (Me.[Page] = 1)

    That works fine. However, because the Page Footer picture is around 4cm in height, I now have a blank 4cm Page Footer on all subsequent pages. On all pages beyond the first I want the text to go to the bottom of the page. Also the report is made up of multiple sections (entered as subreports) each of which can vary in height.

    Is there any way that I can either reduce the size of the page footer on subsequent pages or remove the page footer altogether where it is not required.


    As far as I can see this cannot be done as you cannot change the height of any section after printing has started.

    Or perhaps someone can think of another way of achieving this.

    Many thanks

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    will check further!

  3. #3
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If you cannot put a control (in your case, an image control?) in any section and drag the lower bar of that section over top of it, how do you expect to resize it so that these images are no longer visible? Your solution might be to make the first page a separate report and put that in a sub report control in the header of a new report. Size the header of the main report so that the image controls placed at the bottom appear to be in the footer. Whatever text you have for the first page would have to be in controls that have their grow/shrink property = yes if you want to place the images just underneath. That should leave the rest of the report showing up on subsequent pages, but in the sub report.

    Without a better understanding of what your report actually looks like, I'm just throwing out ideas here.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Force Report Footer to before Page Footer
    By Charles CL in forum Reports
    Replies: 15
    Last Post: 01-21-2016, 12:06 PM
  2. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  3. Replies: 2
    Last Post: 10-15-2013, 09:30 AM
  4. Replies: 0
    Last Post: 02-11-2009, 06:43 PM
  5. Page Footer Top
    By RHall in forum Reports
    Replies: 3
    Last Post: 12-15-2005, 09:35 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums