Textbox Multiline

Hi,

I get some huge text from a cell in Excel to the Textbox in my form, which is set to Multiline and have scrollbars. The problem is I couldn't get the exact format of the text --> meaning, the spaces between the lines. In Excel, I'm having the list of lines with numbers 1,2,3...But when it retrieved from Excel, Textbox shows it as a paragraph. How can I format the Text??? :rolleyes:

Regrads,
Hems.

Have you tried using the RichTextBox control?

This allows you to format text so should hopefully solve your problem.

hi,

But the text in the Excel is entered by the user. So I don't know where it have the spaces between the lines and all. So how can i get & store what exactly the user types?? :confused:

Quote:

---

Originally Posted by haihems

hi,

But the text in the Excel is entered by the user. So I don't know where it have the spaces between the lines and all. So how can i get & store what exactly the user types?? :confused:

---

You can't, because Excel applies its own formating rules to the user input.

Hi wossname,

Can't he import the text and then do a split on VBCRLF?