[AccessD] hard carriage return in query

Aw man, you're kidding.  Lemme try it.....

D'oh!  

Works perfect. 

I've been using vbCrLf so long, I forgot the order. 

Thank you.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Monday, February 08, 2010 2:47 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] hard carriage return in query

It should be 13,10 - not 10,13

--
Stuart

On 8 Feb 2010 at 14:40, Rocky Smolin wrote:

> 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