Rotate text 90 degrees in Access '97 Report

Try this link to do it using API calls:

http://www.mvps.org/access/api/api0050.htm

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..

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

Carey

If you can find fonts with rotated characters, f.e. "Arial rotated 90", you need not additional features :-)

Let us know the result of your test Carey...

"Arial rotated 90" would be perfect!  any suggestions on where to find this?

Maybe you can make it yourself using some Font Editor. Now the problem is to find Font Editor :-)

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.

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

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

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!  

ssam, don't forget that you have to distribute the fonts along with your app.

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 :-)

CareyMBilyeu:
>ssam, don't forget that you have to distribute the fonts along with your app.

as well as additional ActiveX

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

Dedushka:

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

Jim

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 :-)

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.

But for other label you need a new bitmap:-(

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 ;-)

This way we shall reach up to picsels and shall collect from them any characters ;-)

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)

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

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."

Thanks.