Resizing an Access 2010 report to print 1 page wide

[minnichj]

Is there a way to force an Access 2010 report to resize so all columns print out on one page (I'm looking for something similar to the "Fit to:" Page setup feature in Excel)? VB Code preferred.

[NeoPa]

As an Access report is designed for a particular page size this question makes little sense. If you choose to use columns then you set the column-width to fit your design. I don't believe it does it for you but once you've worked out the width of the page; the number of columns and the space between each column then working out the column-width value is pretty straightforward .

[minnichj]

Thanks

Thanks NeoPa:

This is why I have rarely used the Access Report feature in the past. Access Report design has always been so cumbersome. It's much easier to export it and call a procedure from the shell app as I have been doing for years. I just implemented Access2010 and was looking for a new solution to an old issue.

Thanks for the update.

Cheers.

[NeoPa]

It's true. There are limitations to Access reporting, but it's a very powerful feature nevertheless.

I believe it's not uncommon (I use it myself sometimes) to produce an Excel spreadsheet from the results instead. This can be extremely flexible and gives the bonus advantage of allowing the user to play with the results (Produce charts etc). This can be managed by either DoCmd.TransferS preadsheet or Application Automation (or even both in some cases).