Detect Line wrap in Table or Textbox

[Abroad]

I want to neatly fit addresses onto a label; they may be between 3 and 10 lines long, and between 1 and 50 characters per line.

I want to adjust the font size up and down to make the text as big as I can but with no lines wrapping, and no lines lost off the bottom.

I don't really care if it's a table cell or a textbox, as I can precisely set the size and position of either of them.

I found almost the perfect answer on mvps.org, this uses TextFrame.Overflowing, but that only kicks in once text disappears off the bottom of the textframe, not if lines start to wrap.

Can I detect if a table cell or text in a textbox is actually wrapping?

Any suggestions welcome. Thanks :banghead:

[TonyJollans]

This can be difficult but you might be able to use .

Range_reference.ComputeStatistics(wdStatisticLines)