Resize to fit control

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

Dave

Does anyone know a way to automatically adjust (shrink)
the font size to fit a specific size bound control instead
of having text that doesn't fit truncated?
 
People like me who are sight hadicapped would not
appreciate font sizes changing. A text box should always be
set to the maximun width of the control. Maybe you could
use the "Can Grow" property on the text box.

Jim
 
I do not reccommend your approach but here is a solution:
http://www.lebans.com/autosizefont.htm
Updated June11. 2001

AutoSizeFont.zip is a database containing a function to automatically
resize a Control's Font to fit the current record's contents. Works in
the Form's Current and/or Change events.

Version 2: Updated to use the new ,more accurate, fTextHeight function.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top