Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2008

Tip: Looking for answers? Try searching our database.

Report Layout

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sharan - 28 Mar 2008 10:33 GMT
Does anybody know how column headings can be displayed vertical to take up
less space on the page rather than horizontal. Is it possible? As I have too
many columns which i need displaying on one page in my MS Access Report. Can
anyone give me any suggestions?
Allen Browne - 28 Mar 2008 12:50 GMT
Open the report in design view.
In the Properties box, on the Other tab, set the Vertical property to Yes.
Then resize the label/text box.

Some versions of Access have problems with displaying the fonts vertically.
If you run into this problem, change the font to Arial CYR.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Does anybody know how column headings can be displayed vertical to take up
> less space on the page rather than horizontal. Is it possible? As I have
> too
> many columns which i need displaying on one page in my MS Access Report.
> Can
> anyone give me any suggestions?
Sharan - 28 Mar 2008 13:01 GMT
thanks this works for the data that is displayed in the report however the
column headings cannot be set to vertical as there is no option to do this?

> Open the report in design view.
> In the Properties box, on the Other tab, set the Vertical property to Yes.
[quoted text clipped - 9 lines]
> > Can
> > anyone give me any suggestions?
Stockwell43 - 28 Mar 2008 14:04 GMT
Hi Sharan,

Are you referring to the Label (Shows the name of the field)? If so, Open
you report in design view drag down the Detail Bar to open the space, click
on the label and go into the properties. Use the Width and Height fields to
adjust your label. OR, drag down the Detail Bar to open the space, click on
the label and left click and hold the center square on the top border line
and drag it up and the grab the middle square of the right boder line left
click and hold and drag it in(or to the left). This should do the trick.

> thanks this works for the data that is displayed in the report however the
> column headings cannot be set to vertical as there is no option to do this?
[quoted text clipped - 12 lines]
> > > Can
> > > anyone give me any suggestions?
Sharan - 28 Mar 2008 14:15 GMT
what if the labels are not in the "Detail" Section but are in the "Page
Header" section. i tried moving the labels into the "Detail" section however
the labels keep appearing for every row that appears in the report!is there a
way of showing the column labels just once?

> Hi Sharan,
>
[quoted text clipped - 22 lines]
> > > > Can
> > > > anyone give me any suggestions?
Stockwell43 - 28 Mar 2008 14:27 GMT
Your labels should be in the Page header section and you don't want to move
them in the detail section unless you want your report designed that way.
Sometime if I have a lot fields on a report I will put my labels in the
detail section because it makes it easier to view but it's all personal
preference. I only told to move the detail bar down because there is more
room go down than moving the page header up because then you'll be squeezing
the report header section. But if that's easier for you then do that. In
either case, your main objective is to open the space between the Page Header
and Detail section. Whichever bar you decide to drag to accomplish this is
will give you the same end result. However, your report title will have less
room and may not look the way you want when you view the report. It may look
too scrunched. Let me know how you make out.

> what if the labels are not in the "Detail" Section but are in the "Page
> Header" section. i tried moving the labels into the "Detail" section however
[quoted text clipped - 27 lines]
> > > > > Can
> > > > > anyone give me any suggestions?
Sharan - 28 Mar 2008 14:24 GMT
thanks to all for responding to my question with your help i have managed to
solve my problem. thank you!

> Does anybody know how column headings can be displayed vertical to take up
> less space on the page rather than horizontal. Is it possible? As I have too
> many columns which i need displaying on one page in my MS Access Report. Can
> anyone give me any suggestions?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.