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