Line break in text area

shadowshadock Posted messages 1 Status Membre -  
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   -
Hello,

Here is my problem:

I need to create a form containing a table with a dropdown menu in the left column and a text box in the right column. The form must be protected so that users can select from the choices in the left list and then enter information in the text box on the right.

I'm currently in developer mode and there are no issues with the dropdown lists. The problem arises with the text box.

Indeed, I cannot get it to automatically create a new line. As a result, I only have one line, and any text that exceeds the text box is no longer visible.

I would like the text to continue onto the next line as soon as it is longer than the text box, and for the column to expand so that all the text is visible.

I have therefore gone into design mode in the properties of my ActiveX control "text box", and there are plenty of options available. So I selected "multiline true", but nothing works, and I'm unable to get a line break. If I choose "autosize true", the line break occurs but with every letter...

Anyway, if anyone has any ideas??

Thank you in advance, I'm on the verge of depression ;)

2 réponses

shadowshadock
 
Uh, I tested that but it doesn't change anything...

If it's an ActiveX control, you need to set the EnterKeyBehavior property to True, the Multiline property to True, and the WordWrap property to True as well.

If I set "autosize True," it makes a line break for every letter...
4
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
A test is attached
https://www.cjoint.com/?3CyxKYaujaj

argitxu
0
shadowshadock
 
My document is available here:

http://cjoint.com/?0CAlWIV5rfK

What I would like is that, once the document is protected (restricted to "form filling"), we can write in the text fields of the "subject" and "description" columns, and that line breaks are automatic as soon as we reach the end of the column. The rows would adjust to the size of the text, but the columns should remain fixed.
0
argixu Posted messages 5292 Registration date   Status Contributeur Last intervention   4 842
 
Good evening

By sticking with ActiveX controls, you would need to predefine the height of the text area to fit the expected text over multiple lines. Not very convenient. I’m not sure if it’s possible with a macro.

What’s the advantage of using ActiveX controls for your file? Because with legacy forms, you would have exactly what you’re asking for (example attached in your file: https://www.cjoint.com/?3CBxRHVw2yT)

Argitxu
0