Shrink font size (for lack of a better Subject Line)

[Dave]

Not really a big issue but if there is an easy way to solve:
Text box or memo box. These are set with a desired font size on a Report.
Is there any way for the font size to "shrink as needed" depending on the
amount of text being entered on its source form (actually source table).

This IS NOT important enough for any very complicated or extensive coding.
But if the is a "property setting" or reasonably easy coding I would be
interested.

Thanks for reading
Dave

 

[Douglas J. Steele]

There's no property in Access that will do that, and I don't believe that
the coding would not be that simple. You can check whether Stephen Lebans
has anything at http://www.lebans.com. If he doesn't, then it probably can't
be done.

 

[Marshall Barton]

Not really a big issue but if there is an easy way to solve:
Text box or memo box. These are set with a desired font size on a Report.
Is there any way for the font size to "shrink as needed" depending on the
amount of text being entered on its source form (actually source table).

This IS NOT important enough for any very complicated or extensive coding.
But if the is a "property setting" or reasonably easy coding I would be
interested.

Download the fTextHeightWidth function at www.lebans.com

The code will then be something like:

For fs = 12 To 5 Step -1
If fTextWidth(thetextbox) < thetextbox.Width _
Then Exit For
Next fs
thetextbox.FontSize = fs

 

[Dave]

Thank you both

Dave

 

[Douglas J. Steele]

In my defense, Stephen's got that under Forms, which is why I missed it!

 

[Marshall Barton]

In my defense, Stephen's got that under Forms, which is why I missed it!

No defense needed Doug. Missing something on a site that
has that much stuff is perfectly understandable. ;-)