Print form in pdf to fit in one page

[mari_hitz]

Hi All,

Hope you are all good. Please note that I have an access database with a report that comes from a list with a lot columns of information, they are all needed.
When I want to print the report on PDF I would like all the columns to enter in one page. I have set the page layout to landscape with Legal paper, however it does not work.

On excel, when I would like to do it, I have a vba code that prints the sheet in pdf on one page with page setup property set. Is there any way I can achieve the same with Access?

Thanks and regards!

 

[Ranman256]

Make a report, set the borders, page edges so they fit in a legal paper.
Then print using the acFormatPDF option....

Docmd.openReport "myReport",,acFormatPDF

 

[sxschech]

If you are referring to excel's fit to page or scaling options, there doesn't seem to be a fit to page option, however, you can use scaling percentages to adjust page contents to fit on the page in access. It is not easy to find and I haven't figured out how to use vba for it. Post #8 in this thread will give you the steps to do scaling. https://access-programmers.co.uk/forums/showthread.php?t=287157&highlight=scale