[AccessD] hard carriage return in query

Hi Rocky,

There's an easier parameter --> vbNewLine

Use this in place of chr(10) & chr(13).

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, February 08, 2010 4:40 PM
To: 'Access Developers discussion and problem solving'
Subject: [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/>