Resize text in textbox in a report (1 Viewer)

guestbb

Registered User.
Local time
Today, 07:23
Joined
Jul 14, 2015
Messages
44
I have a report where there are textboxes that in some cases can contain text that is longer then their width. What I want to find out is how can I using VBA make text change its font size to smaller to fit the text.
I have looked at lebans TextHeightWidthVer45 but i couldnt open it because it is in mdb and I have office 2013.
Does anyone have any idea how to make it change font size without changing the size of textbox and where to put this code. also the maximum font size would be 11.
 

Ranman256

Well-known member
Local time
Today, 10:23
Joined
Apr 9, 2015
Messages
4,339
dont make it difficult. just change the text font to size 9 in design.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 14:23
Joined
Feb 19, 2013
Messages
16,553
here's the converted .mdb
 

Attachments

  • TextHeightWidthVer45.zip
    62.3 KB · Views: 183

Users who are viewing this thread

Top Bottom