Punctuation in Addresses

[RexesOperator]

I found this code by stopher and a variation of it that Bob Larson gave me (I use it to sovle a different problem):

FullAddress:
([AddressLine1]+(Chr(13) & Chr(10))) &
([AddressLine2]+(Chr(13) & Chr(10))) &
([AddressLine3]+(Chr(13) & Chr(10))) &
([AddressCity]+(Chr(13) & Chr(10))) &
([AddressCounty]+(Chr(13) & Chr(10)))&
([AddressPostcode]+(Chr(13) & Chr(10)))&
([AddressCountry]+(Chr(13) & Chr(10)))

It works fine for the most part, but how do I control punctuation?

For example "Toronto, Ontario. Canada". Or "Belfast, Northern Ireland" when there is no province/sate/county?

 

[boblarson]

You can use the + character to be able to add it in if they exist. So, like:

+ ","

 

[RexesOperator]

Cool - works like a charm.

God I'm gald I found this forum

 

[RexesOperator]

I reiterate (thank you search!):

Cool - works like a charm.

God I'm gald I found this forum