If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Carriage Returns in Expression Builder
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 |
#2
|
|||
|
|||
Carriage Returns in Expression Builder
Use either vbcrlf or Chr(10) & Chr(13)
-- Steve Arbaugh ACG Soft http://ourworld.compuserve.com/homepages/attac-cg "Joe Cooke" wrote in message ... 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 |
#3
|
|||
|
|||
Carriage Returns in Expression Builder
Out of interest (if you know), does vbCRLF actually translate to the
normal end of line CRLF 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" 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 =--- |
#4
|
|||
|
|||
Carriage Returns in Expression Builder
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 ... Out of interest (if you know), does vbCRLF actually translate to the normal end of line CRLF 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" 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 | |
Display Modes | |
|
|