Automatic font changes?

[Mark Murphy]

Here's a good one. I have a report with a small circular area in which I print 4 lines of information. So long as the record to be printed can remain within that small circular area I want to use font size 10. If, however, any line at font size 10 would print outside the circular area, I want the font size automatically bumped down to 9 for that line, and if 9 is too big, to 8. As many lines as possible, I want to keep at the original font size 10. Now this is not too much to ask of a great program like Access, is it? Has anyone out there figured a way to do this and could you please share it if you have? -Thanks, Mark