vertical alignment>>>>>>>>>>

vertical alignment>>>>>>>>>>

Post by Kris » Sat, 01 Nov 2003 16:01:46


Can anybody help me how to get vertical alignment text
starting from bottom to top. Thanks in advance.


vertical alignment>>>>>>>>>>

Post by Steve Scha » Sat, 01 Nov 2003 17:41:56


As far as I know, the only way using Access's native functionality is
for vertical text to go top-to-bottom. Have a look at

- Steve Schapel, Microsoft Access MVP

On Thu, 30 Oct 2003 23:01:46 -0800, "Krish"


vertical alignment>>>>>>>>>>

Post by Marshall B » Sat, 01 Nov 2003 23:01:50

Nothing native in Access for this. However, you can use
Stephen Lebans' TextHeightWidth function (
to calculate how much vertical space the text requires.
Using that value, you can then adjust the text box's Height
and Top properties so that the bottom of the text appears at
the desired position.

Dim lngHgt As Long
lngHgt = fTextHeight(Me.thetextbox)
Me.thetextbox.Top = Me.thetextbox.Top _
+ Me.thetextbox.Height - lngHgt
Me.thetextbox.Height = lngHgt

If the text box has a border that won't look right using
this approach, then make the border transparent and use a
rectangle control to display the border.
MVP [MS Access]

vertical alignment>>>>>>>>>>

Post by Stephen Le » Sun, 02 Nov 2003 01:08:47

There's sample code here showing how to do Center Vertical Alignment.
Just change the calculation to do Bottom alignment: is a database containing a function to
allow for vertical centering of the contents of a Label or TextBox
control. Works with both Forms and Reports.

Access 2000 only!

Stephen Lebans
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.