Sizing

[eveCalypso]

Hello All,

This is actually a follow-up with a twist from an earlier post. I mentioned that when I create a VBA form on the fly, Autosize yields unexpected results - and does not autosize correctly at all.
I need to ascertain the width needed for my text however (for a checkbox),
is there a good way of determining the width required from the length of the string contained in the checkbox??
Please please let me know if you have any ideas.

At the moment, I something like (not quite of course ;-)) :
chkBox1.width = Len(trim(givenString)) * aConstAdjustment + checkboxWidthAdjustment

Regards,
EvE

 

[strongm]

Check out TextWidth

 

[eveCalypso]

Sorry to be a pain,
but I can find very little on TextWidth in my VBA helpfile (in fact, next to nothing).
It sounds exactly like what I need.
Can you give me a tip or two on how its accessed please?

Best Regards,
EvE