Output form to PDF "shrink to fit"

[GraeagleBill]

The code below works fine to send the form to a PDF in landscape orientation, but it doesn't quite fit on a single page. I can't find any references to where I can also specify "Shrink to Fit". Any ideas?

Forms(Me.Name).Printer.Orientation = acPRORLandscape
DoCmd.OutputTo acOutputForm, "frmNorthTower", acFormatPDF, "c:\Revel\RDS\FloorPDFs\North4.pdf"

[Gicu]

As you probably know already forms are not really meant for printing, using reports for that is the preferred approach for most developers. That being said I don't think there is a "shrink to fit" property that you can set either manually or programmatically. You should try to set that form's printer properties, such as the designated (PDF) printer, orientation and margins (I found that I need to set the margins to 0 or close to it and that is not possible with actual printers but it is with most virtual PDF printers).
https://docs.microsoft.com/en-us/off...inter-settings
To change the default printer and reset it:
https://www.accessforums.net/showthread.php?t=70523

Cheers,

[GraeagleBill]

I can't find the setup dialog for the form so I can set the margins.

(And yes, normally this kind of application is better suited with a report. With a bit of design hindsight, the functionality with the current app might have been provided using a report UI had the user made known the variations in using the app. A re-design at this point is not even remotely justified.)

[GraeagleBill]

I found it, somewhat obscured in the externals, but nonetheless. 0.116 is as close to 0 top and bottom as I can get. It almost fits, so I'll tweak the form a bit to see if I can squeeze it into a single page.

[sxschech]

Although one can't seem to do shrink to fit as in Excel, it may be possible to manually adjust the scale (percentage) of the print page such as 80% rather than 100%. I have used this technique when the information won't fit on the page by using a printer driver capable of post script. This is my first post here, so hope it is ok to refer you to the steps I outlined on another forum. It was written back in 2016, I tested it out and still works, however, I already have a post script printer driver installed. To follow my original steps, I tried manually adding a new one and not sure if because I'm on Windows 10 or using a work computer, it does not pull up a list of printers like it did back then, so I couldn't just pick any printer from the list - meaning if you aren't able to pick a printer capable of postscript, the capability to scale won't be available. It should work with a pdf printer drive too.

Since it sounds like you are printing a form rather than a report, you won't get a preview of the percentage adjustment, whereas in a report print preview once the scale percent has been changed, it updates the display and you can then see if you need to adjust the percentage up or down if it is too small or still truncated.

You only need to follow the add a printer steps if you do not already have a postscript printer installed, otherwise, you can skip down to the part about page setup.

see Post #8 16-JUN-2016

https://www.access-programmers.co.uk.../#post-1491765



--I never did learn how to automate or program the scaling with vba --

[GraeagleBill]

Thanks for your thoughts and suggestions. There's no printer postscript during the pdf creation automation, so it didn't even come up during the investigation. As it is, the shape of the form will either fit into a standard page or it's too big. The end user can exercise whatever choices are available with their pdf viewer they desire, but I have to provide a single page rendering. As I posted, I set the page margins to minimum (0.116") and tweaked the form slightly to accomplish the acceptable single page rendering.