Dynamic Reports, Rotated Text Labels and MDEs

[Tony Zoccolillo]

I have a report that is a Chain-of-Custody document and contains a section
with rotated text labels. I'm using Mabry RoText ActiveX control. Since
the control cannot be tied to a recordsource, and I can't modify it from
code at runtime (not allowed), I am forced to open the report and change the
label captions prior to running the report from a function. Although it
works great, this is not allowed in an MDE. I want to bring the database to
an MDE and the first and potentially easiest solution would get a rotated
text label that can have a recordsource so i can tie it to a table value.
Does anyone know of such a control? Short of this solution, is there any
other approach I am missing. I want rotated text, so this part is not
flexible.

Thanks,
Tony Zoccolillo

 

[Jesse Aviles]

On the properties sheet go to Other Tab, on Vertical set to Yes.

 

[Sam D]

Is the vertical property of standard textboxes insufficient for your needs?

HTH
Sam

 

[Marshall Barton]

I have a report that is a Chain-of-Custody document and contains a section
with rotated text labels. I'm using Mabry RoText ActiveX control. Since
the control cannot be tied to a recordsource, and I can't modify it from
code at runtime (not allowed), I am forced to open the report and change the
label captions prior to running the report from a function. Although it
works great, this is not allowed in an MDE. I want to bring the database to
an MDE and the first and potentially easiest solution would get a rotated
text label that can have a recordsource so i can tie it to a table value.
Does anyone know of such a control? Short of this solution, is there any
other approach I am missing. I want rotated text, so this part is not
flexible.

Maybe you can have better luck using Stephen Lebans'
RotateText procedure at www.lebans.com

 

[Stephen Lebans]

Also, in addition to the non ActiveX solution there is an ActiveX
control that can be Bound to a field.
http://www.lebans.com/xrotatetext.htm

The non ActiveX solution is here:
http://www.lebans.com/rotatetext.htm

--

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