Resize PDF for Access Report

Posted on 2006-05-18
Last Modified: 2013-11-28
I have several PDF files which I downloaded. I want to be able to print them as reports in access, where I will have the fields automatically populated. However when I insert them into a new report, through  Insert --> Object  --> Create from File the report is not a full page but instead the Width is about 6" and Height about 8" instead of the full page dimensions of 8 by 11. Also when the PDF files are opened in Adobe they are full sized and can be printed full sized, its only when they are loaded into access when they are reduced in size. Does anyone how how to format the PDF to be a full page report in access?
Question by:SchmidtZ28

    Accepted Solution

    When I inserted the file into the MS Access report it was a small size, but I was able to drag it to the size I wanted. Can you do that in the design view of the report?

    Author Comment

    Yes I can drag it to the dimension of 8 by 11 however the actual report stays the small size and does not adjust. Instead the added area, about 2 inches on the right (or however much you expand the report) is just blank. So instead of expanding the PDF object in the report is just adds blank area to the report.
    LVL 8

    Assisted Solution

    Check your default paper size settings....Either in Adobe or Access...I have a similar problem many times when I crerate PDF reports from SQL to Crystal report and PDF...

    Author Comment

    The PDF when opened in Adobe is the proper size and the properties of the file say Page Size: 8.5 X 11 in, which is correct. The problem is with Access not keeping the correct dimension when imported in. I can't find any options in Access which allow changes to the default paper size.

    Author Comment

    Ok I figured it out... You have to import the object in, Go to properties and under the format tab change the height and width to 8 X 10.8, then under Size mode select Stretch. The font gets stretch too and doesnt look 100% clear, but it'll do.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now