multiple lines from a query...NO CODE !!

[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

 

[dhookom]

Try swap your Chr(10) & Chr(13) for Chr(13) & Chr(10).

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]