A calculation field that uses the TextSize function can alter the size of the text shown on your label. But that's the easy part. If you want a script to automatically size the text in each label perfectly, this gets pretty complex, (but it can be done). But if you want to set up a layout where you see a field sized to fit the label with a pair of buttons that change the size of the text until they perfectly fit, this can be quite simple to set up.
Say your text field is called "LabelText". Then a calculation field can be set up as:
TextSize ( LabelText ; SizeField ]
SizeField can be defined to auto-enter the most commonly used text size as a starting value when the label record is created.
A button can use:
Set Field [YourTable::SizeField ; YourTable::SizeField + 1 ]
To increase the size of the text shown in the calculation field.
A second button can use:
Set Field [YourTable::SizeField ; YourTable::SizeField - 1 ]
to decrease the size of the text.
You'd put the calculation field on your layout in place of your labelText field.
Thanks, Phil. I'll try this.