Results 1 to 3 of 3
  1. #1
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071

    Suppress Last Page


    I have a Report with 2 Group Headers and Footers. First Group = PCP, Second Group = Hedis Measure. In the PCP Footer I have the Property ForceNewPage set to After. In the ON_format Event of the same Group I have the code: If [Page] = [Pages] Then PCPFooter.ForceNewPage = 0 But I'm still getting a blank page at the end of the report. I'm sure I'm missing something but not sure what it is?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Read about a variety of causes and solutions for this issue.

    Review this one http://groups.google.com/group/micro...43970a21a52594
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,071
    That worked. I no longer get the blank last page. The report runs perfectly as requested. I do foresee however, that at some point they're going to want an overall summary at the end of the report. Fortunately that will be a future enhancement if I'm correct so I'll worry about it then. May not happen (I hope)

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

Similar Threads

  1. Suppress warning save changes to layout of table
    By bbrazeau in forum Programming
    Replies: 7
    Last Post: 02-13-2012, 01:57 PM
  2. Suppress spell check error message
    By sabre1 in forum Forms
    Replies: 1
    Last Post: 03-24-2011, 09:58 AM
  3. Suppress new record on continuous forms
    By ajetrumpet in forum Forms
    Replies: 0
    Last Post: 09-07-2010, 09:30 PM
  4. Page break on report inserts empty page between
    By Galadrielle in forum Reports
    Replies: 0
    Last Post: 07-07-2010, 04:18 AM
  5. suppress subtotals when only 1 record
    By schristy in forum Reports
    Replies: 3
    Last Post: 02-15-2010, 10:00 AM

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