PDF file size

Question

I have a form that we fill out and then email a pdf file to a vendor. I have the following code on a button

Private Sub pdf_Click()

DoCmd.OutputTo acOutputForm, "Hillcrest Marker Request", acFormatPDF, "S:\Monument Files\Foundation Requests\Hillcrest" & "Marker Request Form " + Me.Decedent_1 + " " + Format$(Now(), "mm-dd-yyyy") & ".pdf"

End Sub

It works but it makes a 4 page pdf because the form is wider and taller than a standard 8.5"x11" size. I don't need to print the pdf file, so I'm wondering if there is a way to output a pdf as the original size of the form as a 1 page file. The form is 8.75" x 13". I can't make is smaller since the background of the form is our vendors form image.

Thank you,

John

Answer 1

I didn't. We called the vendor and asked for permission to resize the form. They were ok with it. I might try the report to see if it works since I might run into this issue again.

Thank you for your help.

Are you trying to fill out a PDF form that came from the vendor? If so, you might be interested to find out how to do that instead of printing a report or a form that simulates the PDF form. Just a thought...

Answer 2

I didn't. We called the vendor and asked for permission to resize the form. They were ok with it. I might try the report to see if it works since I might run into this issue again.

Thank you for your help.

Answer 3

Have you tried a report and output that as the pdf instead of the form?