Text Box that displays several fields

[sek0910]

I have a report based on an underlying table that has
separate fields for streetaddress, city, state and zip.

I want to print the entire address on one line in a text
box(?) on a report. I can use an unbound text box to
build the expression, but only if each individual field
of the table has it's own textbox control on the report.
Is there any way to build the expression with references
to the underlying table so I don't have to create an
invisible bound text box for each field? When I attempt
to build the expression with reference to the table, I
always get a request box asking me for input, as Access
seems to be interpreting the table name that is in
brackets as a request for manual input. Thanks

 

[Fons Ponsioen]

Delete all the textboxes you may currenly have on the
report related to the data elements of streetaddress,
city, state and zip.
Now place a new unbound text box and in the text box type:
=[streetaddress] & ", " & [city]&", "& [state] & " " &
[zip]
all on one line.
This should give you what you described.
Hope this helps.
Fons