Results 1 to 11 of 11

Thread: Text rotation

  1. #1
    TonyM
    Guest

    Text rotation

    Is there any way to print control text vertically in Access 97 reports.

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

    Re: Text rotation

    Not with native Access 97 controls. There are, I believe, third party controls that will allow you to do that.
    Charlotte

  3. #3
    TonyM
    Guest

    Re: Text rotation

    Thanks. Do you know where I might get them.

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

    Re: Text rotation

    Can you do this in a2k

  5. #5
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text rotation

    Yes. Set the vertical property of the text box to Yes.
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

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

    Re: Text rotation

    I can't endorse any of the vendors because I haven't tried any. However, I know that Stephen Lebans has something on his excellent site at <A target="_blank" HREF=http://www.lebans.com/rotatetext.htm>http://www.lebans.com/rotatetext.htm</A>.
    Charlotte

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

    Re: Text rotation

    Hi Steve

    My text control prints (top to bottom) vertically OK in a2k, however I

  8. #8
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text rotation

    John,

    You might try setting up your rotated text in Excel. Then, you can copy it to the clipboard, edit as needed and pop it into an image control in Access. Or, you could tell your label to look for the image file you just edited.

    Of course, this idea won't be very efficient if you have to do this more than once. Then, as mentioned above, third-party controls are a much better alternative.

    HTH,

    Tom

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

    Re: Text rotation

    Hi Tom

    Print Vertical Text (Bottom to Top)?
    A2k (9.0.3821) SR-1

    After much research to print vertical bound control text on my cleint

  10. #10
    2 Star Lounger
    Join Date
    May 2001
    Location
    Wichita, Kansas, USA
    Posts
    177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Text rotation

    Just a warning.

    After finding this thread while searching the forum for a solution to a similar problem -- we downloaded and used the Tilt 1.2 program John mentions in his post.

    Seemed to work like a charm.

    Except that this was a report on an shared Access database out on a group company drive. So whenever anyone else tried to open the report, they would get an error message that it was looking for the Tilt 1.2 function. (we are using Access 2003)

    so, in other words, we would have had to put Tilt on the machines of everyone wanting to view or work on the report from the database. So this obviously was not the best solution.

    We removed Tilt and dropped back to using the cut/paste from Excel method to rotate the text the direction we needed.

    pribb

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

    Re: Text rotation

    pribb

    That is corect

    Tilt12.exe installs to C:Program FilesTilt12Tilt12.dll on each client's computer

    I only needed it for one report.

    Not familiar with Excel, what would the cut and paste code you suggested look like?

    Thanks, John

Posting Permissions

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