How do I programmatically resize "Label" to what ever text?

[Alphix]

How do I programmatically resize "Label" to what ever text?



I have text that can be a paragraph sometimes and then a small sentence.

I would like to automatically resize a label as desired using VBA.

[June7]

Why is label caption dynamic? Is this actually a textbox bound to field? Textboxes on report automatically grow in height to fit content.

Programmatically changing size of label control to fit content is not practical, especially with proportional font.

[Missinglinq]

As June7 said, doing this kind of thing without using a mono-spaced or fixed-width font is simply not practical. Like him, I have to wonder about what, exactly, you underlying need is, here. There may be other ways to accomplish your task, but we need to know your needs are, here.

Linq ;0)>