Carriage Returns in Expression Builder

  • Thread starter Thread starter Joe Cooke
  • Start date Start date
J

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
 
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?

Use either vbcrlf or Chr(10) & Chr(13)
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
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!)


Peter R. Fletcher said:
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
Click to expand...
=---
 
Back
Top