[AccessD] hard carriage return in query

Stuart McLachlan stuart at lexacorp.com.pg
Mon Feb 8 19:45:27 CST 2010


There are places where you can't use VBA intrinsic constants and have to use Chr$(13) & 
chr$(10).  In a query is one such.

-- 
Stuart

On 8 Feb 2010 at 18:48, Dan Waters wrote:

> 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





More information about the AccessD mailing list