combine two fields

[Guest]

I have two fields "City" and "Province" I somehow want to have them on my
report beside each other with a comma between and to "automatically truncate
any extra space - for example:

Toronto, Ontario
Montreal, Quebec
Vancouver, British Columbia

Thanks !

Ty

 

[Rick Brandt]

I have two fields "City" and "Province" I somehow want to have them
on my report beside each other with a comma between and to
"automatically truncate any extra space - for example:

Toronto, Ontario
Montreal, Quebec
Vancouver, British Columbia

Thanks !

Ty

Use a ControlSource of...

=[City] & ", " & [Province]