concatenate different fields to run together with a comma

  • Thread starter Thread starter Beaugie
  • Start date Start date
B

Beaugie

I am designing a report and I want the address section to run together with
comma and spaces where appropriate, such as:
Mississauga, FL 56569
Racine, WI 53555
Milwaukee, WI 55565

I do not want big gaps or spaces between fields
 
I am designing a report and I want the address section to run together with
comma and spaces where appropriate, such as:
Mississauga, FL 56569
Racine, WI 53555
Milwaukee, WI 55565

I do not want big gaps or spaces between fields
Click to expand...

Use an unbound control.

=[City] & ", " & [State] & " " & [Zip]
 
Back
Top