Multiple Fields in a Textbox

R

rye1982

I want to add several fields into a textbox, similar to a Mail Merge effect
in Word.

How can do this?

E.g. I have city and state fields and want a text where it shows the city
(from the field), adds a comma automatically, and adds the state (from the
field)

Thanks very much.
 
J

Jeff Boyce

Use a query to concatenate the fields. Your city/state/postal code might
look something like:

CSZ: [City] & ", " & [State] & " " & [PostalCode]

as a new "field" in a query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top