mutiple line text help !!

[TRYP]

INSERT INTO tblTest ( the_Memo )
SELECT
[tbl_Data].[data_1] & ":" & [tbl_Data].[data_2]
& Chr(10) & Chr(13) &
[tbl_Data].[data_3] & ":" & [tbl_Data].[data_4]
AS Expr1
FROM tbl_Data;

IM TRYING TO RUN A QUERY LIKE THAT
TO GET THIS

DATA:data
DATA:data


in a textbox but im getting this...

name:keith||age:32


where the pipes above are non printables...?!!?!

help !!
-tryp

 

[JoeAtWork]

Carriage return (13) should go before linefeed (10). Switch your Chr's and it should work. I tested the following:

SELECT [A_UserID] & ":" & Chr(13) & Chr(10) & [A_First_Name] AS Special
FROM Attendee

 

[Pampers]

I used JoeAtWorks tip (to get a bit of practice on the insert query), and it worked:

INSERT INTO tbl_Test ( [the_Memo] )
SELECT tbl_Data.data_1 & ":" & tbl_Data.data_2 & Chr(13) & Chr(10) & tbl_Data.data_3 & ":" & tbl_Data.data_4
FROM tbl_Data;

Pampers
Just let it go...