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?
bryansworld 0 Newbie Poster
AndreRet 526 Senior Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.