Add a new line on textbox from code

[klasse]

Hello,

I have a recordset with which I get values of a table (customer address, city, country) and then I want to put it into a textbox, everything into one.
I tried to do something like

txtbox =!CUST_ADDRESS & CHR(13) & !CUST_CITY

But this wouldn't work. It displays the address, then a funny simbol and then the city, everything in the same line. The box is big, as for 5 lines.
I somebody could help me, please?

Thanks,

Klasse

 

[jebry]

Hi!

Instead of CHR(13) try VbCrLf.

hth Jeff Bridgham
bridgham@purdue.edu

 

[softlad]

I think to get you answer you should re-phrase the question as I don't know what you're tying to do????????