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

  • Thread starter Thread starter Dave
  • Start date Start date
D

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
 
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.
 
Dave said:
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.
Click to expand...


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
 
Douglas said:
In my defense, Stephen's got that under Forms, which is why I missed it!
Click to expand...


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