Setting height and width of label using VBA

[twine]

I am writing a module to import forms/reports from
external sources. In these sources labels/textboxes are
defined with a height and width based on a font.
My question is: what is the relation between the height
and width of a label in Access vs. the height and width of
the text to be used as caption. There seems to be
some 'off-set', i.e. the labels are bigger then the
textsize. Anyone any idea(s) ?

 

[Ronald Dodge]

You can go to Leban's web site as the url link is below. His Text
Width-Height samble DB has the necessary code for the most part in it with 2
exceptions. The 2 exceptions are one, if you have the controls on pages of
a multi-tab strip, it errors out and the other being that the line spacing
between rows of text within a list box is 15 twips.

http://www.lebans.com/textwidth-height.htm

Here's a link to an article on Microsoft's website about the line spacing in
textboxes and labels.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/htm
l/acproLineSpacing.asp