ROTATING TEXT

[longbillduck]

Can text be rotated on a report or form?

Does anyone know how to rotate text 90 or 270 degrees

I need to generate a report where this or something close has to happen

THANKS

Art

 

[bobbster2000]

If you go to the textbox properties and click on the "Other" tab, you'll see a section that says "vertical". Try that out and see if that's what you want.

 

[UncleJack]

If you have MSPublisher you can create WordArt that has rotated text. Then take the text block and paste it onto your report. The WordArt is then treated exactly like an image. You can also design all sorts of stuff in Publisher and use it as a splash screen at the front end of an application.

Uncle Jack

 

[longbillduck]

bobbster2000, thanks for the tip, I didn't know of that function, unfortunatley,that wasn' quite what I was looking for, maybe another time I'll be able to use it.

I guess I was trying to rotate the word counterclockwise 90 degrees, instead of clockwise, which your tip gave me.

I did try UncleJack's suggestion, I have WORD, which has WordArt and I was able to copy and paste into the form

 

[juxtabeginner]

If you want the VBA solution which allows you to rotate text on forms and/or reports you can download the code from

http://www.lebans.com/rotatetext.htm

Its freeware and it works.