How do I wrap text in label

[alemg99]

I am creating a form, and need to "wrap text" on some labels. Can grow is not what I am looking for, but something that allows me to have multiple lines.

[aytee111]

<Ctrl>Enter starts a new line

[alemg99]

I need it to be auto formated as I have 150+ observations on my table. Any ideas?

[aytee111]

What does "auto formatted" mean? Why are you using a label control, wouldn't a ListBox work better for you?

[davegri]

IF you are appending observations into one long string as the label caption, do this:

dim sLabelString as string
sLabelString = obs1 & vbcrlf _
& obs2 & vbcrlf _
& obs3 & vbcrlf _
.
.
& obs9 & vbcrlf
mylabel.caption = sLabelString

The vbcrlf will cause a new line.