Resize to fit control

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?
 
J

Jim/Chris

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
 
S

Stephen Lebans

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.
 
Top