I have a question, I searched previous discussion but none seems to solve.
I have a calculated text field which might have from 100 up to 1000 words.
My need is to write a script where the font size of the text is calculated so that all the text will be included into the field boundaries.
Needs to run both Mac and Windows and font size is a bit different (even fonts like Courier) so I need to calculate with script.
This sounds like a good place for multiple conditional formatting tests which make the text size smaller as the character count increases. Advantage is it doesn't mess with the actual text/data, just its appearance.