Vertical alignment on forms (and reports)

[khughes46]

I have some labels I want to align vertically. They read top to bottom. Is there a way to align them to read bottom to top?

[ItsMe]

Reverse their order????

[khughes46]

It still would read from top to bottom with the words on the right side. I want the words on the left side reading bottom to top, just like you can do it in Excel.

[June7]

You want to rotate the label? Access has very limited intrinsic capability for this. The Vertical property allows only top to bottom. Can use TextAlign, TopMargin, BottomMargin, LeftMargin, RightMargin properties to manage text alignment within the label.

Might find some 3rd-party add-in controls that can do more or learn how to build your own custom controls - very advanced programming and I've never gone there.

[khughes46]

I just got a crazy idea. What if I created the labels I want in Excel and did a cut and paste. It worked, at least for the form. Haven't tried the report yet. Don't have time to try it now but i will do it later today and get back here.

[June7]

I did a test of what you describe. This creates an OLEUnbound control with embedded image clip. Does the same thing on report. As long as you are happy with the results, guess you have a solution.

[khughes46]

Yeah, I found the same thing. I may have to go to an add-in like crystal reports.