Results 1 to 5 of 5
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    573

    Surpress page header text box of Report Foot page

    I have put Facility Name on the Page Header since the page breaks After the Facility Name footer. I want the Facility name to print at the top of each page in the report, except on the page with the Report Footer which is on a page by itself. I haven't been able to find an event to set the visible property to false on the Report footer page.

    Is there a way of doing this?

    Thanks in advance,



    Paul

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    In the OnFormat of the page header:
    If Me.Page = Me.Pages Then .....

  3. #3
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,277
    just a suggestion. If you know the pagecount (e.g. perhaps the records count if it is one record per page), perhaps you can set its visibility based on the page number not equalling page count

  4. #4
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    573
    Page count is unknown. I'll try the Me.Page = Me.Pages when I get back to it.

  5. #5
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    573
    Me.Page = Me.Pages work perfectly.

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

Similar Threads

  1. Replies: 4
    Last Post: 04-19-2017, 09:36 AM
  2. Replies: 1
    Last Post: 11-11-2016, 07:02 PM
  3. Page Header & Forced Page Break
    By Donnydon in forum Reports
    Replies: 1
    Last Post: 09-08-2011, 08:24 AM
  4. Replies: 3
    Last Post: 08-07-2011, 09:22 PM
  5. Page Break after foot, but not for last section
    By thestappa in forum Reports
    Replies: 0
    Last Post: 11-24-2010, 03:31 PM

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