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?