textbox in a continuous form can be WRAP ?

[joe55555]

hello,



i have a textbox in a continuous form.

what i need is when the text is long, i want the textbox to wrap as it does in excel (vertically) so the text will be all visible i don't want to use the scroll bar.

i searched many places i couldn't find any topic concerning that!!! :S

any ideas please ?

thank you

[June7]

The text will wrap but if the text is longer than the size of textbox, the scroll bars will display.

Textboxes on report have a CanGrow property, not on form - that's why there's a scroll bar.

[joe55555]

that's why i need to wrap the textbox without the use of scroll bar.
i guess there must be a code that tests the length of the text and of the textbox and then allow the text to stretch the textbox vertically automatically once the text is larger than the textbox size.
did you get my idea ?

[June7]

The question has been asked before. The answer is - probably not. Most people use proportional fonts which means characters have different widths so it is not as simple as counting the number of characters, which is what Len function does. And not only are the characters different widths but characters will be different sizes and different spacing between characters for different fonts. And if you could somehow determine the actual total width of all the characters and spaces and set the textbox height, if the form controls are arranged vertically, the resized textbox would cover or be covered by controls below it. Also, setting a form control's property affects that property for ALL instances of the control, they would ALL show the size of the most recent setting.