Rotate Page Headers Anticlockwise

[Guest]

I want to rotate page headers anticlockwise by 90 degrees. In the Properties
for Label, the setting of vertical field rotates the orientation clockwise.
Any help?

 

[Wayne Morgan]

See Stephen Lebans's web site.

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

 

[Guest]

Thanx It worked. but everytime I have to open that file , create the label ,
cut it and then paste it to my database/form or report. Slightly laborious.
Am I doing it the right way?

 

[Wayne Morgan]

Import the class module in the example file into your file then add the menu
item as described in the Readme form in the sample file.

I tested with the AccRotextWMF.zip file in the first link. If you downloaded
one of the other files, there should be instructions in them also.

 

[Guest]

Hi, if I could expand the original poster's question a bit further. Is there
a way to do it without graphics? The text I need to rotate for my own reports
are going to be based on data entered on a form (i.e. it will change every
month)

 

[Wayne Morgan]

Try Stephen's ActiveX control in the second link
http://www.lebans.com/xrotatetext.htm

Place it in the report and set its Control Source as you would a textbox.

 

[Guest]

I am using Access 2003 and I tried stephen's method from
http://www.lebans.com/xrotatetext.htm. It did not work.
Does it work only for Access 97?