CODEWITHSUNDEEP
vbams-accesspdf
Mike Slaught
Mike Slaught

Reputation: 89

Printing Microsoft Access PDF report to custom size

I need to print a Microsoft Access report to a PDF. The dimensions of the PDF output must be 8.375in x 1.375in (Meaning the entire size of the page must be this size when outputted). Does anyone know of a way to do this?

Thanks!

Upvotes: 2

Views: 1774

Answers (2)

xShen
xShen

Reputation: 572

Microsoft provide a method to set some printer property`s Printer.PaperSize

And a PaperSize enumeration

other option from access-programmers.co.uk is

way to custom the printer papar size; Example my custom size is 200mm x 110mm

1) Go to Control Panel>Administrator Tools>Print Managment>Print Server>Form. In action select manage forms and create a new form saiz, In form decription set the form to 200mm and 110mmm. finaly simply rename the form name as " 200X 110"

2) On Access Report, open the report in design view. In tools bar select page setup > paper size > "200X110"

hope that will help you.....

Upvotes: 1

Gustav
Gustav

Reputation: 56026

I guess you will have to create this custom paper size and assign it to the PDF printer.

Then, prior to printing, set the Printer object to use that paper size:

enter image description here

This can be a bit tricky, and I have never used this, so I can't provide details, sorry.

Upvotes: 1

Related Questions