Results 1 to 3 of 3
  1. #1
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94

    Reports getting cut off horizontally when SaveTo PDF

    I have a report with several subreports. Previously it was working before and many changes have been made. Although no changes with margins, widths, page sizes, etc.

    The issue at hand is that on print preview, everything looks great - just about ready to publish the report. However, when the report is saved/exported as a PDF either manually or through a VBA script, the contents of the report seem "zoomed to fit" and the right 1-1.5 inches is cut off. I have tested all of the subreports and they all act the same.

    I am thinking it's a system setting, but no changes have been made to the system.

    There are no printers installed on the system in question, I am only using the internal Access export to PDF functions.

    I have also seen the same problem being exhibited with another report which has not been modified. So I doubt it has to do with the report(s) in question, rather it's probably an Access or Windows issue. I tend to lean towards Access since as stated previously, I am just using the internal Access export to PDF functions.

    Any ideas here?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Never encountered this. If you want to provide db for analysis, follow instructions at bottom of my post.
    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
    chris.williams is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2011
    Posts
    94
    Thanks June - I resolved the issue. I rebooted the machine. Through troubleshooting, I went back to an unaltered report and the same problem happened. I then opened another version of the db and it happened there too. I then opened an unrelated db and likewise. The only thing left was the engine, or the OS. So I rebooted and viola!

    Thanks for your input.

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

Similar Threads

  1. summing yes/no horizontally
    By adgsfh in forum Queries
    Replies: 2
    Last Post: 10-26-2011, 01:13 PM
  2. Compiling items with same ID horizontally
    By tomahs in forum Access
    Replies: 3
    Last Post: 06-04-2011, 12:36 AM
  3. Find field value Horizontally
    By jgelpi16 in forum Programming
    Replies: 11
    Last Post: 01-24-2011, 04:21 PM
  4. Text box resize horizontally
    By cowboy in forum Reports
    Replies: 1
    Last Post: 06-09-2010, 09:30 PM
  5. Expand field horizontally
    By jonsuns7 in forum Reports
    Replies: 1
    Last Post: 10-15-2009, 04:54 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