[AccessD] hard carriage return in query

But will it work in the field name of the QBE?  vbCrLf didn't.  And therein
lay the problem.  For seniors.

Rocky
 

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

 

 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com