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 Exprssion Builder...Again
Hi.
I am really trying...but I cannot get a carriage return in Expression Builder. I got the reply from "SA" on this subject and he/she said the following: Use either vbcrlf or Chr(10) & Chr(13) I tried, but I must not know the proper way to insert this in Expression Builder. What I want to do is have an Access report give me a phone/address directory. I have type in the following: =[First Name] & " " & [Last Name] & [Address] & [City] & ", " & [State] & " " [Zip] & [Phone] & [email] I get all of the information that I want to appear on the report. But it is all on one line. Now, I could do separate text boxes, but then I would have all of these blank lines for those who do not have an email address or a phone number, or even an address. So, what is the simple solution (or is there a simple one) to create a carriage return in Expression Builder? Thanks again and have a GREAT WEEKEND!!! Joe |
Thread Tools | |
Display Modes | |
|
|