I know I've seen a script that will change the font size when the number of characters in a field exceeds X, so the results should allow the entire text to be seen by the user.
Yes, I've done this a number of times. You do it with Conditional Formatting. You do a Length calcluation on the size of the field and if it is greater than a certain length such as 50 characters, then apply the Additional formatting option to reduce the font size. It works pretty well other than what it measures is the number of characters and not how wide the font is. So if a line is in all CAPS, it might have as many characters before it reaches the margin and needs to be made smaller. And if you had a line of lower case "i"s, then the formula will change the font to smaller long before it reaches the right margin. However, in general it works ok. Not the best solution, but better than nothing at all.
Retrieving data ...