By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,129 Members | 1,196 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,129 IT Pros & Developers. It's quick & easy.

Resizing an Access 2010 report to print 1 page wide

P: 2
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.
Nov 4 '11 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,761
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.
Nov 11 '11 #2

P: 2
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.

Nov 15 '11 #3

Expert Mod 15k+
P: 31,761
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.TransferSpreadsheet or Application Automation (or even both in some cases).
Nov 15 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.