Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,658 questions
export of MS Access report to pdf change size of landscape format
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(182.40000000000003, 59%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEH%3C/text%3E%3C/svg%3E)
Eli H
1
Reputation point
Hello, After export to pdf DoCmd.OutputTo acOutputReport, strRepName, acFormatPDF, pathreport & "Report_somename.pdf"
it happens sometimes that page size change from 18.67 to 14.68 and it cuts few records from page and last column. Pdf looks like as on screenshot.
Office
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
395 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,934 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
879 questions
{count} votes
-
Viorel 117.6K Reputation points2023-07-11T08:33:03.1133333+00:00 Did you specify the page size in Page Setup tab of Access, or maybe you used this technique: https://social.msdn.microsoft.com/Forums/en-US/d14388cc-e68a-4593-b811-d9f8eaddb423?
Sign in to comment
Sign in to answer