K
Keith G Hicks
I'm trying to write code to calculate the height of a "can grow" text box
given a particular width, font name and font size. I found something on the
web that doesn't work for some reason
(http://www.experts-exchange.com/Databases/MS_Access/Q_20898220.html). So
I'm currently using automation to send the text into a text frame in a word
doc and then resizing the text frame and getting the height of that. IT
works quite well in office 2003. But it doesn't work in office 2000.
Apparantly the TextFrame.Autosize function is not part of 2000. I'd prefer
to do the whole thing from within Access without using word but not sure
that is possible. I also have tried to figure out some code to do it in
word without using a textframe. It works but doesn't seem as accurate as I'd
hoped. I'm sure I'm doing something a little wrong in there. In any event
I was wondering if anyone knows of a good way to do this strictly in ms
access. Any help would be appreciated. It seems a shame that MS hasn't
after all these versions of Access just included a property of can grow text
boxes that can be used in the OnFormat event of a report.
Thanks,
Keith
given a particular width, font name and font size. I found something on the
web that doesn't work for some reason
(http://www.experts-exchange.com/Databases/MS_Access/Q_20898220.html). So
I'm currently using automation to send the text into a text frame in a word
doc and then resizing the text frame and getting the height of that. IT
works quite well in office 2003. But it doesn't work in office 2000.
Apparantly the TextFrame.Autosize function is not part of 2000. I'd prefer
to do the whole thing from within Access without using word but not sure
that is possible. I also have tried to figure out some code to do it in
word without using a textframe. It works but doesn't seem as accurate as I'd
hoped. I'm sure I'm doing something a little wrong in there. In any event
I was wondering if anyone knows of a good way to do this strictly in ms
access. Any help would be appreciated. It seems a shame that MS hasn't
after all these versions of Access just included a property of can grow text
boxes that can be used in the OnFormat event of a report.
Thanks,
Keith