combining text fields into one field

[cwash]

Is it possible to join two or more text fields into one field? What I want, if possible, is to combine several fields of text such as "address", "street", "city", "state",...,' and have them combined as if they were one field such as "1 One Street City State". The combined field is a filing system I use. Right now the fields are in different places within the form so to save time, I would like to have them together.

TIA

 

[Fizzio]

This can be done but do not store the concatenated field in the table, just display it on the form. Create an unbound field and in the controlsource, use something like

=[address] & [street] & ", " & [city] & ", " & [state]
where [field] are your field names in the table/query.

HTH

 

[cwash]

Thanks Fizzio!

Just what I was looking for.