asked on

Resize PDF for Access Report

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?

ASKER CERTIFIED SOLUTION

shuurik

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SchmidtZ28

ASKER

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.

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SchmidtZ28

ASKER

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.

SchmidtZ28

ASKER

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.