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
.
|