[AccessD] hard carriage return in query

Dear List:

I am trying to write an update query to transfer addresses in multiple
fields from one table to an address field in a second table which is a memo
field.

I put Expr1: [fldVendorAddress1] & Chr(10) & Chr(13) & [fldVendorAddress2] &
Chr(10) & Chr(13) & [fldVendorAddress3] & Chr(10) & Chr(13) &
[fldVendorZipCode] &  Chr(10) & Chr(13) & [fldVendorCountry] as the field in
the QBE grid.

but in the target table there are no hard carriage returns as I would expect
from & Chr(10 & Chr1(13). Even as a select query the results are all
concatenated.

Is there a trick to this?

MTIA

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>