View Single Post
  #3  
Old May 27th, 2004, 01:59 PM
external usenet poster
 
Posts: n/a
Default Carriage Returns in Exprssion Builder...Again

=[First Name] & " " & [Last Name] & vbCrLf & [Address] &
[City] & " " & [State] & " " [Zip] & vbCrLf & [Phone] &
vbCrLf & [email]

If this does not work in the expression builder, leave
the textbox unbound and use the following code in the
report open event:

TextboxName = [First Name] & " " & [Last Name] & vbCrLf &
[Address] & [City] & " " & [State] & " " [Zip] & vbCrLf &
[Phone] & vbCrLf & [email]


-----Original Message-----
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

.