Results 1 to 10 of 10
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vertical Text (Access 2002)

    Hi--

    I'm trying to get fancy, now. Danger. I used a vertical label in XP. How do I change the direction of the text?

    Here's what it says in the help:
    You can specify how vertical text will be displayed, edited, or printed in the control by setting the Vertical property. If set to Yes, the starting point for inputting text is the upper right corner of the control (the ending point is the lower left corner of the control). If using full pitch characters, the display and print directions are the same as the control for horizontal text. If using half pitch characters, it shifts 90 degrees to the right. The cursor is also rotated 90 degrees to the right in a vertical text control.

    What is a half pitch character? Anyone know?

    TIA!

    Cecilia :-)

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Vertical Text (Access 2002)

    The only thing I could find was an obscure reference where full-pitch meant the double-byte characters such as you find in Kanji, Katakana and other languages, while half-pitch referred to the more or less standard ANSI set of characters that only takes a single byte. I have no idea whether that's what the 2002 helps means or not. <img src=/S/groan.gif border=0 alt=groan width=16 height=15>
    Wendell

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Text (Access 2002)

    Hmmm. I'm going to interpret that as meaning you can't do vertical text rotation unless you speak some (for me) obscure foreign language.

    Oh, well.

    Thanks for finding that, Wendell! :-)

    Cecilia

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Vertical Text (Access 2002)

    Well, you can do vertical labels OK, but they run from the top right only as long as you are using a European based language. But you can't run it from the bottom left, which apps like Excel and Word allow you to do. Not sure what imposes that constraint other than the developers, but . . . they do let you do the same thing with text boxes too - now that's scary! <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Wendell

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Text (Access 2002)

    As a user interface designer (and I use that term loosely), my goal is to be as scary as possible.

    After all, don't people love horror films?

    I think I'm getting a bit punchy. Thanks for trying to help me with this, though :-)

  6. #6
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Text (Access 2002)

    <P ID="edit" class=small>(Edited by WendellB on 16-Jan-03 13:37. Activate link to post)</P>Hi Cecilla

    Check out post Post: <post#=152308>post 152308</post#> for additional vertical text solutions

    HTH

    John

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Text (Access 2002)

    I _SO_ totally wish I could use third party stuff....

    unfortunately I work for the government, and they insist on controlling me. I'm not even allowed to defrag my own PC, so installing a 3rd party control is way out of the question.

    It's okay, they'll live without the vertical text until I can find some way of doing it myself.

    :-)

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Vertical Text (Access 2002)

    You may have the wrong idea about Stephan Lebans stuff. Take a look at http://www.lebans.com/rotatetext.htm He has a couple of sample databases that rotate text and. They don't require 3rd party controls. The only things you would be using are objects that are already built into Access (like the image control) and Windows API calls, which he's already written for you. His samples are written in Access 97, so you have to convert them when you open them in a later version, but they work, and you can learn a lot from them.
    Charlotte

  9. #9
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Vertical Text (Access 2002)

    the quick and dirty way that i use is to simply rotate the label in excel the copy and paste the cell in access, hope that this helps. <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

    r3x3

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Vertical Text (Access 2002)

    Thanks--again--Charlotte! I'm sorry that I dismissed this example, it is really cool.

    I was more focused on the label that Access 2002 provides, because you'd think that if they're going to provide the ability to have a vertical label, then it'd be flexible enough to provide a way to move the text around in it.

    Thanks again for your help!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •