Results 1 to 2 of 2
  1. #1
    maxvolticz3 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2020
    Posts
    1

    Why there is an additional blank page when export to pdf that is not shown in print preview on a rep

    I have a report in Ms Access that has 5 subreports in the detail section and number page in the page footer section. Between the 4th and 5th subreport there is a page break. all subreports and the detail section are set to property can grow and can shrink yes. The report width is 7.3 which considers the margin and should fit in a 8 1/2 x 11 page. And there is only one single line code for the report



    Code:
    Me.PageBreak.Visible = Me.Report1.Report.HasData


    The question is why on print preview the report shows only two pages which is correct and when export to pdf, it would export with an additional blank page which didn't show on the print preview?
    The additional blank page has a small gray rectangle on the top part.





  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,568
    Hi

    This is because one of your Subreports is too wide.

    Make them narrower by trial and error until it displays as it should.
    You can PM me if you need further help.
    Good Reading https://docs.microsoft.com/en-gb/off...on-description

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

Similar Threads

  1. Replies: 4
    Last Post: 03-16-2017, 02:06 PM
  2. Replies: 1
    Last Post: 11-11-2016, 07:02 PM
  3. Replies: 4
    Last Post: 01-20-2016, 02:24 PM
  4. Replies: 21
    Last Post: 08-06-2013, 01:02 PM
  5. Fields Go Blank On Print Preview
    By VariableZ in forum Reports
    Replies: 4
    Last Post: 03-07-2013, 11:00 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