View Single Post
  #1  
Old May 27th, 2004, 12:06 PM
external usenet poster
 
Posts: n/a
Default 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