Hi I'm working in VBA and I need to try to get long names to fit in a textbox I cannot increase. Is there a way to get the font size to scale down when a name is found to be too long to fit in the textbox?

8 Years
Discussion Span
Last Post by AndreRet

Change the font name to 'Garamond' and the size to 6. This is probably the best READABLE font with only 6 points font size. If the long name still does not fit, you will either have to word wrap the text, which will increase your textbox size in height. This I think is about the only solutions available for you at the moment.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.