BUG FIX!!!!!!! Thanks to Marshall Barton for the "Hey it's great but I don't think it works perfectly" Email. I finally took the time to figure out exactly what is going on when Access renders text. Unfortunately now I have to go back and update all of my other projects to make them as accurate as this one!
TextHeightWidth.zip is a replacement for the Report object's TextWidth and TextHeight methods. It is multiline aware and can work in both Report and Form views. Includes a sample report to show you how to autosize individual controls with different formatting on the same line to simulate RTF style text.
Version 4.5: Increased accuracy of auto sizing for a ListBox.
Version 4.3: Added sample Form to demonstrate auto sizing for a ListBox.
Version 4.2: Added report to demonstrate auto sizing to mix text formatting on one row.
Version 4.1: First Release that works!!!<grin>
Version 1.0: First Release