how to adjust font size in control box if needed?

[Gustavson]

I'm generating a report in access97. I have a control box in which text is displayed. If the text in the box is too long it gets cut off at that point and part of it is missing when printing the report. Is there a way to automatically adjust font size if the text is too long for the control box?

Hope this is enough info...
Thanx
Gustavson

 

[AlexMidd]

Well, if there is I'd love to know about it. As far as I am aware this is a nicety that does not exist. It would solve a lot of problems for me as I have reports where the details in certain fields vary in size from a couple of words to many lines. I just have to ensure that the text box is large enough to hold the largest amount of data that might occur. Have fun! )

Alex Middleton