VERTICALLY Aligning Text in a Text Box

[Paul Howarth]

I have a rather large text box in a report. Sometimes the Control Source is one sentence. Sometimes the Control Source is a paragraph.

I want to keep "Can Grow" and "Can Shrink" both set to "No".

Given this, is there a way to VERTICALLY align the text in the text box? Excel calls this "Middle Align".
[imgnothumb]http://bytes.com/attachments/attachment/6097d1329340320/excel-middle-align.jpg[/imgnothumb]

[ADezii]

Const conCENTER As Byte = 2

Me![<Text Box Name].TextAlign = conCENTER

[NeoPa]

Wouldn't that align it in the centre horizontally rather than vertically as requested ADezii?

[smartchap]

Please see the following site
** Link removed **

it may be of help to you

I have modified the code for you as :

Private Sub Command2_Click()
  Label2.Caption = "This" & vbCrLf & "is a" & vbCrLf & "long" & vbCrLf & "label to" & vbCrLf & "see how it reacts to the centering"
  Label2.Left = Picture1.Width / 2 - (Label2.Width / 2)

End Sub

[ADezii]

Wouldn't that align it in the centre horizontally rather than vertically as requested ADezii?

Oops, sorry about that, I guess I was 'misaligned'! (LOL)