Exporting report to PDF

[matey56]

Hi all,
I have a report in Access and I would like to add a button that will export it to a PDF in 11x17 size. Is that possible? I can export to PDF no problem, but it's the size that I'm not sure about. Thanks

[Minty]

I think you simply set the paper size for the report, and the pdf should mimic it?

[matey56]

I think you simply set the paper size for the report, and the pdf should mimic it?

That doesn't work. I think the answer might be to go to print preview.

[matey56]

I set the paper size of the report to 11x17 and landscape. When I export it to PDF on my machine it fits the report to one page. When anyone else exports it the page is cut into 2. What am I missing?

[Minty]

It may be to do with their default printer settings.
Did you set it to a specific printer or just leave it as default?

[matey56]

It may be to do with their default printer settings.
Did you set it to a specific printer or just leave it as default?

I don't have it set to any printer. I'm just telling it to export to PDF, save it to their desktop and open it. It works for me and another user I tested with, but for a different user it opens spread across 2 pages. It has to be some Adobe settings but I'm not sure which.

DoCmd.OutputTo acOutputReport, "rpt_Submission_Planning", acFormatPDF, "C:\Users\" & Environ("username") & "\Desktop\Submission Planning Report.pdf", True

[Minty]

So the same file opened on different machines behaves differently?
Or the locally generated file is different?

e.g. If you create the file on your machine and it's fine, but you email it to your colleague and they open it and it's not OK?
In the latter case it's definitely a local setting.

[matey56]

So if I click the export to PDF button it opens the PDF with the report fit to one page (desired outcome). If my colleague clicks the button it opens the PDF on two pages. If i send her the one page PDF I generated she sees it as one page.

[Minty]

Okay, that would seem to indicate a setting within Access on her machine.
Or possibly a default windows setting for paper size or margins on her machine.