Full Version: reports, multiple fields in 1 text box
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
redhouse93
I want to get more than one field to appear in one text box in a report, such as, "Address" and "City State, Zip" and "Name" Same Record.
Anybody know how?
MattJ
Set the control source to something like
= [Field1] & " " & [Field2] & [Field3]
redhouse93
It worked, I didn't have enough &'s
thanks
MattJ
np thumbup.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.