Can font size be changed automatically?

[Terry DeJournett]

I have a report with a field that varies in text length. Some records only
have a small amount of text in the field, while other records have a lot of
text. If I design a report to accomodate the records with largest amount of
text in the field, then when I have to decrease the font to a very small
size in order for it to print (report is actually a 5" round label and the
size and location of the placement of the field is limited. If the record
contains only a small amount text, then the label/report looks strange
because the font is so small.

Does anyone know if the size of the font can be increased automatically
depending on the amount of text in the field?

Thanks,
Terry