Hi all,

I'm creating a very wide report in Access (abt 18"). When viewing, i'm not able to see some part of the report and i have to go to page 2 to see it.
Is it possible to add a horizontal scroll bar to the report so that the user is just able to scroll to the right to see the remainder of the report ? How can this be done ?

Thanks for helping

Hi all,

Have I asked a very basic and stupid question that noone wants to answer or a scroll bar just cannot be added to the reports ?

Can anyone please answer.
Thanks

Just so you don't feel so bad, I've been there too... I was able to design my report around an 11X14 piece of paper and use the landscape layout. Try reducing font sizes and decreasing margins until you can fit it onto a standard sized sheet. It's easy to select one control and format it accordingly, then use the format painter to apply those font settings to many other controls and labels.

You must understand that reports are not for reading on the screen. They are meant for printing on paper. Therefore, you would never have scroll bar on a report, and in Access you cannot add one for this reason. The scroll bar would be located on the datasheet view of a subform in a FORM, not a report.

Since a report is to be printed, you must design your report to match the paper size available to your printer. Therefore, if your printer can only do 8½x11 (letter) paper, your report should be no longer than that. If your printer can handle 8½x14 (legal) or even 11x17, then you can design a report for those.

For those cases, your margins, fonts, font sizes, page orientation (portrait vs. landscape), and number of fields per row will determine how you design the report; but you're always limited by the paper size.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division