Custom vertical format in Report label

[Guest]

Hello,

I'm building a customized payroll report in Access in which some of the
headings have a vertical orientation. The problem is, I haven't found a way
to change the direction of the vertical text. I'd like this text to be read
from bottom to top. So far, I can only produce vertical text that reads from
top to bottom. I'm using Access 2003 with Windows XP Pro.

Warmest regards from Peru, South America.

 

[fredg]

Hello,

I'm building a customized payroll report in Access in which some of the
headings have a vertical orientation. The problem is, I haven't found a way
to change the direction of the vertical text. I'd like this text to be read
from bottom to top. So far, I can only produce vertical text that reads from
top to bottom. I'm using Access 2003 with Windows XP Pro.

Warmest regards from Peru, South America.

Check out Stephen Lebans site:

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

 

[John Spencer]

If you mean you have a control that displays data from a field as
a
b
c

and you want
c
b
a

You can use a VBA function to reverse the character order of the string and
assign that reversed order to the control.


'The following UNTESTED code will change "abc" to "cba". Copy the code to a
module and use ti
Public Function fReverseString(strIn As Variant) As Variant
Dim iLoop As Long
Dim strReturn As String

If Len(strIn & "") = 0 Then
fReverseString = strIn

Else
For iLoop = Len(strIn) To 1 Step -1
strReturn = strReturn & Mid(strIn, iLoop, 1)
Next iLoop
fReverseString = strReturn
End If

End Function


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..