[AccessD] Addresses

I always use a memo field for Addresses. The front end may present a
list of countries, cities and provinces/states/cantons, and I store
these too, but I assemble the address according to a template in the
Countries table. It could be a by-product of the apps I've worked on,
and useless to anyone else, but in Europe the most common address format
places the street number after the street name (i.e. Amstrat 300). There
are many similar variations from country to country or continent to
continent, so I handle it with a template in the Countries table which
looks something like this (for the Netherlands, say):

\StreetName\ \StreetNumber\
\City\, \Province\
\PostalCode\
\Country\

Then it's trivial to use Replace() to dump the actual data into the
template.

I would appreciate input from non-North-Americans on this so I can add
new templates for your countries.

TIA,
Arthur

P.S.
Anyone with specialized knowledge of city-states such as Singapore is
especially invited to contribute!