Wrox Programmer Forums
|
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 March 3rd, 2004, 04:29 AM
Authorized User
 
Join Date: Mar 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default Vertical align in reports

Hello!

Is it possible to align text vertically in MS Access reports?

Thanks,
Janis
 
Old March 3rd, 2004, 09:23 AM
Friend of Wrox
 
Join Date: Jun 2003
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

Yes, click the textbox or label, open its properties, and set its VERTICAL property to YES.

Unfortunately, the direction it goes is not what most people want. The word goes vertical from the first letter on TOP to the last letter on the BOTTOM. That is, when you read it, you have to tilt your head to the right and the bottom of the word is pointing left. That's fine if you put the vertical text on the rightmost side of your report, but most people want it on the left side with the first letter on the bottom and the last letter on the top. :(



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old March 3rd, 2004, 09:46 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you hold your shift key and click the boxes you want to align, then right click you will get a shortcut menu which you can then select Align > Left, Right, Top, Bottom, To Grid. You can also use the menubar options of Format > Align and the same choices.

Regarding rotating text, there are some add-ins available out there which will allow you to rotate text in just about any direction you choose.

Regards,

Beth M
 
Old March 3rd, 2004, 10:07 AM
Authorized User
 
Join Date: Mar 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the answer!

Yet that is not what I meant. With "vertical align" I meant wether the text is aligned to the top, bottom or middle of the box while the letters stay horizontal.

Thanks,
Janis

 
Old March 5th, 2004, 04:12 AM
Authorized User
 
Join Date: Mar 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

So, what I want is not to change the direction of the text (left-to-right, right-to-left, top-to-bottom, or bottom-to-top), but the alignment of the text (like to the right, in the center, to the left, [u]to the top, in the middle, to the bottom</u>).

Can someone help me, please?

Thanks,
Janis

 
Old March 5th, 2004, 09:05 AM
Friend of Wrox
 
Join Date: Jun 2003
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

Oh, OK... you don't want to rotate the text 90°. You want to keep it normal, you just want the text to be positioned either at the top, center, or bottom of a tall label or textbox.

No, there's no way to automatically vertically align text that I know of. Access assumes that if you want to position text vertically, you would just move the entire label or textbox to the position you wanted. So instead of specifying center align to a 3-inch tall label, you have a normal height label and you just click and drag it so the text is approx. 1½ inches from the top and bottom of your 3-inch area.

Barring doing that, the only way to manually position text in a tall label is to click the label once so your cursor is inside the label, place your cursor before the desired text, and move it down by using SHIFT+ENTER until the text is in the middle.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old March 5th, 2004, 09:53 AM
Authorized User
 
Join Date: Mar 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

OK, thanks for the info! :)

Unfortunately, the solution won't really help in this case, as text in the specific box in my report can be either in one row or two rows. So, I cannot align it manually.

Thanks, anyways. :)
Janis

 
Old March 5th, 2004, 10:15 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There is a property, just like you see for this dialog box and word, and excel, and just about anything else, to use for aligning text Left, Right, Center or General. On the properties sheet for the text box, click on the Format tab and then scroll down to 'Text Align'. You will see the four options in the drop-down once you click in the field.

Regards,

Beth M
 
Old March 5th, 2004, 10:17 AM
Friend of Wrox
 
Join Date: Jun 2003
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

Yes, but that's for horizontal text alignment, not vertical.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old March 5th, 2004, 10:20 AM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

picky, picky :D





Similar Threads
Thread Thread Starter Forum Replies Last Post
vertical-align problems chroniclemaster1 CSS Cascading Style Sheets 0 September 3rd, 2008 12:07 PM
Vertical Labels bfoley CSS Cascading Style Sheets 2 November 26th, 2007 02:06 PM
EASY Q: Left-Align and Right-Align DIV? panuvin ASP.NET 1.0 and 1.1 Basics 0 December 16th, 2006 02:02 AM
Vertical alignment for a formula Slon Crystal Reports 1 April 16th, 2006 01:46 AM
Vertical Menu Niaz Pro VB 6 2 October 14th, 2003 06:03 AM





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