By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,946 Members | 734 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,946 IT Pros & Developers. It's quick & easy.

Line/Carriage Return in Access Report Text Box

P: 4
Hello,

I'm using Access 2002 to create a text box that will contain the following information in this format:

Name
Title
Company
City, State
email

I entered the following expression in a text box:

=[FULL_NAME] & Chr(10) & Chr(13) & [TITLE] & Chr(10) & Chr(13) & [COMPANY] & Chr(10) & Chr(13) & [CITY_STATE] & Chr(10) & Chr(13) & [email]

This is the result of the expression:

Name   Title   Company   City, State   email

I've tried using Chr(10) only and Chr(13) only, but I still cannot get each field to appear on a separate line. Does anyone have any suggestions.

Thanks!
May 18 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
Hello,

I'm using Access 2002 to create a text box that will contain the following information in this format:

Name
Title
Company
City, State
email

I entered the following expression in a text box:

=[FULL_NAME] & Chr(10) & Chr(13) & [TITLE] & Chr(10) & Chr(13) & [COMPANY] & Chr(10) & Chr(13) & [CITY_STATE] & Chr(10) & Chr(13) & [email]

This is the result of the expression:

Name   Title   Company   City, State   email

I've tried using Chr(10) only and Chr(13) only, but I still cannot get each field to appear on a separate line. Does anyone have any suggestions.

Thanks!

try using vbLf in place of chr(10) & Chr(13)
May 18 '07 #2

ADezii
Expert 5K+
P: 8,619
Hello,

I'm using Access 2002 to create a text box that will contain the following information in this format:

Name
Title
Company
City, State
email

I entered the following expression in a text box:

=[FULL_NAME] & Chr(10) & Chr(13) & [TITLE] & Chr(10) & Chr(13) & [COMPANY] & Chr(10) & Chr(13) & [CITY_STATE] & Chr(10) & Chr(13) & [email]

This is the result of the expression:

Name   Title   Company   City, State   email

I've tried using Chr(10) only and Chr(13) only, but I still cannot get each field to appear on a separate line. Does anyone have any suggestions.

Thanks!
=[FULL_NAME] & vbCrLf & [TITLE] & vbCrLf & [COMPANY] & vbCrLf & [CITY_STATE] & vbCrLf & [email]
May 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.