textWidth Method for Access 97?

[ShaneBrennan]

I'm writing a simple report, but I have a problem with the title. Because if the header has too many wide letter in it such a WMT, etc it will grow to the next line.

I could limit it to one line, but I would miss off some test. What I really want to find is a way of calculating how wide the text will be in the text box, so I can reduce the font size a little to make it all fit on one line.

I know there is a .TextWidth method in VB6, but is there a similar one for Access reports?

Thanks for any help received in advance.



Shane Brennan

'-----------------------

' Emails: shanebrennan@postmaster.co.uk

 

[dhookom]

Stephen Lebans has a solution (and lots more) at his site

http://www.lebans.com/makefitsingle.htm.

Duane
MS Access MVP