Textbox text visibility

[bcelestia]

I have a fixed dimension Textbox on a spreadsheet. I read variable data
(Text) from a database field and insert it into the textbox. The
spreadsheet is eventually printed. I need to check if all of the text
in the textbox is actually visible to the user. i.e too much text will
be clipped. The text can contain carriage return or linefeed
characters.

If not then I would possibly reduce the font size assigned to the text
box until all the Text is visible to the user.

Does anyone know a method to do this?

 

[bcelestia]

No, What I mean is that the text box has a fixed height & width. If
'too much' text is actually
in the textbox then some of the text is not visible on screen & will
not show on a printout.

I need some code that will detect this so that I can programatically
reduce the font size applied to the text box until all of the text is
visible.