Rotated Text

[Ed Bloom]

How do I get text to display down the right side of the report and have it
rotated downward so as to read it if the report was filed on its side.

I need Last Name and First name to print like this.

Thanks in advance.

 

[Al Camp]

Ed,
I often see Stephen Leban's web site referred to in regards to rotating text...
http://www.lebans.com/rotatetext.htm

 

[Ed Bloom]

Thank you. This only works on lables and not text boxes.
I should have been more clear in my post that is a rotated text box.

 

[Stephen Lebans]

Use the RotateText ActiveX control then if you cannot figure out how to
simulate a boudn TextBox control with the solution Al pointed you to. It was
right on the bottom of the page.
http://www.lebans.com/xrotatetext.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Al Camp]

Ed,
Why couldn't you do this...
MyLabel.Caption = [YourTextFieldName]
I have no idea where your label is situated... Detail, Footer, Header?

You could use the OnFormat Event for whatever section to set the label caption "value"

I have never used Stephen's rotated text, but if you can get a normal label to display
a "hardwired" caption the way you want, then you should be able to update that caption "on
the fly" with a text control value.

 

[Ed Bloom]

Finally got it to work on a form. Still not working on a report.
I will try the ActiveX method.

 

[Ed Bloom]

I'll try. I got the rotation to work on a form just not a report.

Ed,
Why couldn't you do this...
MyLabel.Caption = [YourTextFieldName]
I have no idea where your label is situated... Detail, Footer, Header?

You could use the OnFormat Event for whatever section to set the label caption "value"

I have never used Stephen's rotated text, but if you can get a normal label to display
a "hardwired" caption the way you want, then you should be able to update that caption "on
the fly" with a text control value.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thank you. This only works on lables and not text boxes.
I should have been more clear in my post that is a rotated text box.

 

[Stephen Lebans]

That solution works for both Forms and Reports so you do not need the
ActiveX control unless you find it easier to use.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

I'll try. I got the rotation to work on a form just not a report.

Ed,
Why couldn't you do this...
MyLabel.Caption = [YourTextFieldName]
I have no idea where your label is situated... Detail, Footer, Header?

You could use the OnFormat Event for whatever section to set the label
caption "value"

I have never used Stephen's rotated text, but if you can get a normal
label to display
a "hardwired" caption the way you want, then you should be able to update
that caption "on
the fly" with a text control value.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Thank you. This only works on lables and not text boxes.
I should have been more clear in my post that is a rotated text box.

:

Ed,
I often see Stephen Leban's web site referred to in regards to
rotating text...
http://www.lebans.com/rotatetext.htm

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

How do I get text to display down the right side of the report and
have it
rotated downward so as to read it if the report was filed on its
side.

I need Last Name and First name to print like this.

Thanks in advance.