One major aspect that trips up many novice developers is managing to fit the content within a letter page. As such, we see questions relating to scaling or sizing to fit a page. Sadly, this is one function that Access does not possess.
The obvious solution is to setup the report page to the proper page size and then resize the content to fit those boundaries (minus the margins).
That said, there is a simple little trick that you can employ to get around this limitation should you be in a situation that you can’t redesign a report or need to enlarge or shrink a report for some reason.
- Generate the report in whatever page size that it is design for
- Export the report as a PDF (External Data -> Export -> PDF or XPS)
- Open the generated PDF and then print it, selecting Fit to page as the Scale
This way you can print any size Access report on any other size page.
How will be done this step in access?
> 3.Open the generated PDF and then print it, selecting Fit to page as the Scale
It’s not done in Access, it’s done in the user’s PDF reader of choice. You can automatically open the PDF, but the actually printing must be done manually by the user.
Perhaps a printer instance could be create with the necessary setting and then you could automatically print to it, but I’ve never explored this option, just an idea at this point in time.