Resize PDF for Access Report

Posted on 2006-05-18
Medium Priority
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
  • 3

Accepted Solution

shuurik earned 1000 total points
ID: 16709304
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

ID: 16710894
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.

Assisted Solution

H earned 1000 total points
ID: 16712756
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

ID: 16720632
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

ID: 16720707
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

807 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