Hi everyone,
I tried to increase the size of the detail section in my report, but it apparently has a maximum size of just under 56cm's? Anyway I can make my report bigger than that? I am using Access 2007.
Hi everyone,
I tried to increase the size of the detail section in my report, but it apparently has a maximum size of just under 56cm's? Anyway I can make my report bigger than that? I am using Access 2007.
Do you really need a height of a single record to be greater than 4 pages in height? Have you tried moving laterally as well as vertically?
My report calls several subforms (which are pivot charts). The combined height of these should be greater than 56cm's for the graphs to display big enough to read easily. Right now I am squashing them in.
I have tried making the size of the subforms within the report smaller, and then just allow the subforms to grow according to the size of the pivot chart, but then they start displaying on top of each other. I am not really an Access guru so it's possible I just don't have the settings right.
Try using more width on your report then instead of just going vertically, you'll have to do some extra formatting to get your headers to come out looking alright but if you really can't limit the height of your report it's an option.
Thanks, don't know why I didn't think of using the width myself
It was a bit complicated getting it to print nicely, but its working now...