Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 3rd, 2004, 04:29 AM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
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
Reply With Quote
  #2 (permalink)  
Old March 3rd, 2004, 09:23 AM
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

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
Reply With Quote
  #3 (permalink)  
Old March 3rd, 2004, 09:46 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #4 (permalink)  
Old March 3rd, 2004, 10:07 AM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
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

Reply With Quote
  #5 (permalink)  
Old March 5th, 2004, 04:12 AM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
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

Reply With Quote
  #6 (permalink)  
Old March 5th, 2004, 09:05 AM
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

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
Reply With Quote
  #7 (permalink)  
Old March 5th, 2004, 09:53 AM
Authorized User
 
Join Date: Mar 2004
Location: , , Latvia.
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

Reply With Quote
  #8 (permalink)  
Old March 5th, 2004, 10:15 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
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
Reply With Quote
  #9 (permalink)  
Old March 5th, 2004, 10:17 AM
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

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

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #10 (permalink)  
Old March 5th, 2004, 10:20 AM
Friend of Wrox
 
Join Date: Jul 2003
Location: Houston, Texas, USA.
Posts: 174
Thanks: 0
Thanked 0 Times in 0 Posts
Default

picky, picky :D
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:26 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.