Carriage Returns in Expression Builder

[Joe Cooke]

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

 

[SA]

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

 

[Douglas J. Steele]

From the Immediate window:

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


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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?



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

=---