Rotate text 90 degrees in Access '97 Report

How can i rotate text or a field label in an Access '97 report  (90, 180 or 270 degrees)?  

According to Microsoft, this is a limitation of the program.  They suggested an ActiveX add-in.  Any one know of one that would do this?
LVL 1
ssamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mrt1Commented:
Try this link to do it using API calls:

http://www.mvps.org/access/api/api0050.htm
0
CareyMBilyeuCommented:
Dbi-Tech.COM has ActiveX add-ins that you can use for this, the one you might be interested in is called ctText.OCX. With this, you can rotate text any degree 0-360, you can also set a rotate start & stop timer to give the affect to a spinning text ( I wouldn't recommend-the timer is always calculating). You can dowmload a demo version of the Component toolbox directly from their website.

There phone number is 800-670-8045, you can ask for Al or Phil, they will be able to help you.

HTH..
0
CareyMBilyeuCommented:
Hey MRT1, cool, thanks for the posting. I'll check it out as well.

Carey
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

DedushkaCommented:
If you can find fonts with rotated characters, f.e. "Arial rotated 90", you need not additional features :-)
0
TrygveCommented:
Let us know the result of your test Carey...
0
ssamAuthor Commented:
"Arial rotated 90" would be perfect!  any suggestions on where to find this?

0
DedushkaCommented:
Maybe you can make it yourself using some Font Editor. Now the problem is to find Font Editor :-)
0
TrygveCommented:
If you create the rotated font, the problem would be to put more than one character in a row so that they are nicely alligned. You would probably need to create several labels or controls and put them above each other...

ssam: Go for the article link posted by mrt1.
0
JimMorganCommented:
You might also want to check out FMS's Rich Text control.  You can do almost anything that you want with text in Access with it.  http://www.fmsinc.com

Jim
0
CareyMBilyeuCommented:
Whoa, major code stump with the API calls. Man, talk about adding serious weight to an app!! I think I'll stick to the Dbi stuff, alot easier, (although ya gotta but it)!

CB
0
ssamAuthor Commented:
thanx all!  deduska, please submit an answer and the points are yours.  i found a nice shareware font editor and made what i needed.  however, all answers were excellent and very helpful!  
0
CareyMBilyeuCommented:
ssam, don't forget that you have to distribute the fonts along with your app.
0
DedushkaCommented:
ssam, thank you for accepting my suggestion:
If you can find fonts with rotated characters, f.e. "Arial rotated 90", you need not additional features :-)
0
DedushkaCommented:
ssam, thank you for accepting my suggestion:
If you can find fonts with rotated characters, f.e. "Arial rotated 90", you need not additional features :-)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DedushkaCommented:
CareyMBilyeu:
>ssam, don't forget that you have to distribute the fonts along with your app.

as well as additional ActiveX
0
JimMorganCommented:
Dedushka:

I can see from where I'm standing that your right shoe sole is starting to wear a little thin.  Better watch out!  :-)

Jim
0
JimMorganCommented:
Dedushka:

Of course the big points on this one will keep me back for at least another week.  :-(

Jim
0
DedushkaCommented:
JimMorgan:

Do not worry, Jim, in a pair of weeks you for certain will be in top 5, and first, who will congratulate you is I :-)
0
TrygveCommented:
It seems to me that creating your own font will take more effort than to use the API calls...

If these are static labels you could also consider just creating a small bitmap, insert the text, rotate it and copy/paste the image onto the form/report. This way you don't need to distribute any font/ActiveX for this purpose.
0
DedushkaCommented:
But for other label you need a new bitmap:-(
0
TrygveCommented:
Yes, I know.

How about one little bitmap for for each character put into an ImageList on a hidden form? Then a smart function could format the "label" nicely on the form. This is getting complicated again ;-)
0
DedushkaCommented:
This way we shall reach up to picsels and shall collect from them any characters ;-)
0
ssamAuthor Commented:
thanx for all the help!  found a shareware ap through a basic search on yahoo that allowed creation of a rotated font set (only needed numbers).  thanx again to everyone!  ---ssam (ps., sorry for the delay, been away for the weekend)
0
JimMorganCommented:
ssam:

Can you share the source of this shareware program?  It might be usefull to someone else as well.

I'd hate to be an EE member who finds this question marked PAQ and then pay 30 points to find that the answer was not here.

Jim
0
ssamAuthor Commented:
Sure!  Had to go find it since i didn't bookmark it.  sorry.
go to:

http://home.iclweb.com/icl1/d.w.emmett/

its a shareware program called "Softy."

0
JimMorganCommented:
Thanks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.