Results 1 to 4 of 4
  1. #1
    fabiobarreto10 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    169

    not print blank pages when a subreport is empty

    Friends, I have a report with subreports eight, but sometimes, some sub has no data. Are getting blank pages


    prints how do I fix?
    Thank you.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Google: Access VBA report no data don't print page

    Maybe this will help: http://bytes.com/topic/access/answer...ble-subreports
    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
    fabiobarreto10 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    169
    Thanks for responding and helping. I had earlier in trying to google.
    Put yes to can can expand and shrink,
    for all sections of all subreports also placed time zero for all subreports.
    In the event when loading the subreport I repeat this code for each sub:
    Then if Me.Filho0.Report.HasData
    Me.Filho0.Visible = True
    else
    Me.Filho0.Visible = False
    end If
    In the event if you are not given for each sub I put:
    cancel = True
    As I open the report it is all empty, but when I print, it prints perfectly,
    if the subtree is not show no data
    and also the sub fully expand.
    Only when I open'm not seeing anything.
    Thank you.

  4. #4
    fabiobarreto10 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    169
    thank you for your help, Sorry for being slow to respond, I was without internet.


    I was able to partially resolve. I put a button on the form to open the report.


    Thus, it opens directly in Print Preview, subreports showing correctly and also printing correctly.


    Again, thank you.

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

Similar Threads

  1. Hide Subreport if specific fields are empty
    By hawkins in forum Reports
    Replies: 1
    Last Post: 03-29-2012, 05:08 PM
  2. Blank Pages in my Reports
    By bkvisler in forum Reports
    Replies: 2
    Last Post: 08-21-2011, 03:15 PM
  3. Empty Subreport
    By runbear in forum Reports
    Replies: 5
    Last Post: 04-23-2011, 12:26 PM
  4. Replies: 1
    Last Post: 01-10-2011, 01:08 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 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