Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 4th, 2007, 02:47 PM
Authorized User
 
Join Date: Nov 2006
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default horizontal scroll for a wide report

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

 
Old October 5th, 2007, 10:31 AM
Authorized User
 
Join Date: Nov 2006
Location: , , .
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old October 8th, 2007, 09:30 PM
Registered User
 
Join Date: Oct 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old October 15th, 2007, 12:59 PM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

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




Similar Threads
Thread Thread Starter Forum Replies Last Post
Rich Text Box Horizontal Scroll Bar DavidGreen VB How-To 5 December 15th, 2009 11:54 PM
Add a Horizontal Scroll Bar to a List Box in VBA hewstone999 Access VBA 1 February 28th, 2008 08:31 AM
Horizontal scroll bar when childform is maximize juzjess C# 2005 1 November 7th, 2007 05:04 AM
100% but still too wide? stay_asleep Dreamweaver (all versions) 1 December 16th, 2005 09:40 AM
Wide Character String kochoo Classic ASP Components 0 October 12th, 2003 12:06 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.