Multiple Fields in a Textbox

  • Thread starter Thread starter rye1982
  • Start date Start date
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.
 
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
 
Back
Top