Hi there
I have a label in a gallery. The dimensions are, for example, 113w x 33h. Wrap = On.
The font is OpenSans size 10, which allows me to fill up to two lines of text.
How can I maximise the number of characters that appears within this label over two lines using a formula in the Text property such as:
Left(ThisItem.ColumnName,24)
where 24 is a relative number that depends on the width of the characters.
That is, if ColumnName.Text = "AAAAAAAAAAA AAAAAAAAAAA AAAAAAAAA AAAAAA", I can fit about 24 characters, but if ColumnName.Text = "IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII", I could fit perhaps 50 characters before I would need to trim the text.
Thanks!