Help with label and form width

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

twen - 19 Feb 2007 16:40 GMT

So I have a kind of help form built because I do not understand how to create
an HTML help file. The form loads from a user making a selection from a
previous form of help topics. I have each line designated as a label and a
case statement depending on which topic they chose that will populate the
labels' captions. (LblLine1.Caption = strLine1, LblLine2.Caption = strLine2,
etc.)
My question is that I want the form and all labels to be able to grow or
shrink to the largest string so all are visible. I used an IIF to find the
largest string since there did not seem to be a Max function built anywhere
in VBA, and now I have a value as a long but the width of the labels and
forms are in twips. Any help on finding how many characters are in a twip?

Reply to this Message

Marshall Barton - 19 Feb 2007 17:22 GMT

>So I have a kind of help form built because I do not understand how to create
>an HTML help file. The form loads from a user making a selection from a
[quoted text clipped - 7 lines]
>in VBA, and now I have a value as a long but the width of the labels and
>forms are in twips. Any help on finding how many characters are in a twip?

If you're using a proportional font, there is no formula to
covert the number of characters to the length of the string.
You would need something like the fTextWidthHeight function
at www.lebans.com

Note that I have serious doubts about your approach and I
suspect that you are digging youself into a hole. Can't
you just concatenate the various lines into one long string
and stuff that into a single text box?

Signature

Marsh
MVP [MS Access]

Reply to this Message