Carriage Returns in Expression Builder

's Computer Specifications

Hi,

How does one go about creating a carriage return in MS
Access's Expression Builder? For instance, I want to
create a report that is a address list - have name on one
line, address on the second, etc.

Thanks.

Joe Cooke

's Computer Specifications

Use either vbcrlf or Chr(10) & Chr(13)
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Joe Cooke" <(E-Mail Removed)> wrote in message
news:10e0101c440f6$1799bba0$(E-Mail Removed)...
> Hi,
>
> How does one go about creating a carriage return in MS
> Access's Expression Builder? For instance, I want to
> create a report that is a address list - have name on one
> line, address on the second, etc.
>
> Thanks.
>
> Joe Cooke

's Computer Specifications

Out of interest (if you know), does vbCRLF actually translate to the
normal end of line <CR><LF> sequence when included in a string, or is
its internal representation a single control character?

On Sun, 23 May 2004 15:25:24 -0400, "SA" <~(E-Mail Removed)>
wrote:

>Use either vbcrlf or Chr(10) & Chr(13)

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---

's Computer Specifications

From the Immediate window:

?Len(vbCrLf)
2
?InStr(vbCrLf, Chr$(13))
1
?InStr(vbCrLf, Chr$(10))
2

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Peter R. Fletcher" <pfletch(at)fletchers(hyphen)uk.com> wrote in message
news:(E-Mail Removed)...
> Out of interest (if you know), does vbCRLF actually translate to the
> normal end of line <CR><LF> sequence when included in a string, or is
> its internal representation a single control character?
>
> On Sun, 23 May 2004 15:25:24 -0400, "SA" <~(E-Mail Removed)>
> wrote:
>
> >Use either vbcrlf or Chr(10) & Chr(13)
>
> Please respond to the Newsgroup, so that others may benefit from the
exchange.
> Peter R. Fletcher
>
>
> ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
News==----
> http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
Newsgroups
> ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
=---

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Query expression builder returns text instead of numeric	B+ve	Microsoft Access Queries	3	30th Mar 2008 03:57 AM
String Builder, appending carriage return	TheRain	Microsoft Dot NET	11	26th Apr 2006 09:38 AM
Expression Builder available in Code Builder?	=?Utf-8?B?RnJhbms3Nw==?=	Microsoft Access VBA Modules	3	10th Mar 2005 08:37 PM
expression builder erased my expression	=?Utf-8?B?U3RlZmFubw==?=	Microsoft Access	1	6th Dec 2004 11:17 PM
Carriage Returns in Exprssion Builder...Again		Microsoft Access Reports	3	27th May 2004 02:40 PM