How to bind the text box to note pad format?

[Vincentan]

Hello all friends!
I have a problem here, i have many single line text box in my form and I in certain text box which is only single line text and some will be multi-line text box.

The main point is, I want it to show all the text box in single line in the form even for those which text box is enable to multi-line, and i want to add an click event to particular text box when been click, it show multi-line for those which is multi-line set to enabled.

This is something like we able to bind with note pad for text note entry to a single text box.

Regards

 

[johnwm]

Can you just expand the height of the textbox when needed?

Private Sub Text1_DblClick()
If Text1.Height < 500 Then
Text1.Height = 2500
Else
Text1.Height = 495
End If
End Sub

This is not tested and has no error checking - just to give the idea


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Vincentan]

Thanks! JohnWM and maybe I can try just for a single click and how to set the event for auto return to single line after we had enter the text?

Private Sub Text1_Click()
If Text1.Height < 500 Then
Text1.Height = 2500
Else
Text1.Height = 495
End If
End Sub

There is another question maybe relate to this, how do I expand and show the multi fields listdown view in combobox after i dragdown but initially there is only one fields capture in the combo box before dragdown been click.

For example maybe I want to see there is item no and item desription display in a combo list when I dragdown but before it was only show me item no.

Thanks and please advice

 

[johnwm]

I don't understand your second question. It's usually best to start a new question in a new thread. Read through faq222-2244 for full guidance on this, then start a new thread with details as necessary


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'