Is there a way I can vertically rotate fields and labels on my form so that they read from bottom to top? I've only been able to make them read top to bottom.

Does it really matter?

Anyway, 'Top to Bottom' is in fact the correct way of viewing vertical text. Have a look at any book or video cover spine and you will see that the title always reads from top to bottom.

Not rocket science, but for the labels, you could just type the name backwards. For the fields, you would need to create a custom function to display the letters in reverse order. Something like:

Public Function reverse(txtfield As String) As String
Dim i As Integer
reverse = ""
If Len(txtfield) > 0 Then
For i = 0 To Len(txtfield) - 1
reverse = reverse & Mid(txtfield, Len(txtfield) - i, 1)
Next i
Else
reverse = ""
End If
End Function

KevinM:
Does it really matter why I need to rotate the field bottom to top? :-)

I'm actually trying to replicate a hard-copy form for use in transferring hand-written data from paper to database. On the paper form, some labels read bottom to top.

The users can work with labels going the other direction, but it would be prettier if my Access form looked as much as possible like the paper form. Any suggestions would be appreciated.

(Robear Dyer posted this question for me earlier.)



[This message has been edited by davidbenz (edited 05-30-2001).]

I have used an Active X add in the past, called 'RotateText'.

It's available free from...
http://www.mvps.org/access/

It works on A97 & A2000

HTH

There's an easy way to do this:

-Make the text box 1 character wide and stretch it so that it's tall.
-Use the reverse function from charityg (Interesting - I wrote a function just like this one for someone on exactly this theme a while back here (http://www.access-programmers.co.uk/ubb/Forum5/HTML/001141.html) - great minds think alike?)
-Format the text box to a font named Aachen vertical which you can download from here (http://www.geocities.com/SouthBeach/Shores/9002/)

HTH

Mike

[This message has been edited by Mike Gurman (edited 05-31-2001).]