4,375 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.
Microsoft 365 and Office Development Other
Microsoft 365 and Office Access Development
910 questions
Microsoft 365 and Office Install, redeem, activate For business Windows
Microsoft 365 and Office Access For business Windows
{count} votes
-
Viorel 122.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