Text box question: How to force text to a single row in multiline textbox?

[Jaymond Flurrie]

I have a form where user can add multiple records first to a text box one by one and then "flush" them into a database after he's done - just to avoid the need to open the form in worst case hundreds of time.

So my form looks basically like this:

It confuses the user way too much if a single "record" is spread into multiple lines. How do force my VBA code to print that text (ie. the content of that "Name") to a single line, while keeping the textbox as multiline?

 

[shg]

Set the Multiline property True and WordWrap False.

You'll need line feeds between rows.

Or you could use a ListBox.

 

[Jaymond Flurrie]

Set the Multiline property True and WordWrap False.

You'll need line feeds between rows.

Or you could use a ListBox.

Darn you shg. You make me feel pretty stupid with answer like this! But yes, it works, thanks for the fast reply!

 

[shg]

Lucky guess. Glad it worked for you.