PDA

View Full Version : Solved: Userform caption length



tammytutone
09-29-2008, 12:00 PM
Is it possible to make the caption of a userform 2 lines or more? I have a userform with a very long title and it won't wrap. I just get an ellipsis at the end.

fumei
09-29-2008, 12:34 PM
No. Did you look in Help?


If a control's caption is too long, the caption is truncated. If a form's caption is too long for the title bar, the title is displayed with an ellipsis.

Tip If a control has both the Caption and AutoSize properties, setting AutoSize to True automatically adjusts the size of the control to frame the entire caption.
Note: a Userform does NOT have an AutoSize property.

CreganTur
09-30-2008, 01:25 PM
Gerry's totally correct, as usual (:thumb ) but the truncation of a userform's captioncan be dependant on how wide the userform is. If you can widen it a little, then do so- since it creates more space for the caption.

Otherwise, you may need to look at shortening the name:dunno

fumei
10-02-2008, 08:25 AM
"the truncation of a userform's caption can be dependant on how wide the userform is."

Not can be...IS.

I too would like it if we could have a multi-lined Caption for a userform...but, 'tis not to be. The visible Caption is directly related to the width of the userform.