Line/Carriage Return in Access Report Text Box

[Dee Brooks]

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!

[JConsulting]

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)

[ADezii]

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]