I know I can change font size of a field with a formula in the format text area based on length of string, but is there a way to change font size based on how many lines/carriage returns the memo field contains?
If memo field contains 3 carriage returns, then font size 10
If memo field contains 4 carriage returns, then font size 9
If memo field contains 4 carriage returns, then font size 8
I have this field in a report, but I have limited vertical space to fit it and the field can vary from 2 lines up to 8 lines, so I need to shrink the text so it always fits in the same space of the textbox that the field is nested in.