[AccessD] Addresses

You can search the web for address formats.  There are several sites that
have formats listed.

Christian Brock
APT Program
DSN 221-1936
703-325-1936



-----Original Message-----
From: Arthur Fuller [mailto:artful at rogers.com] 
Sent: Friday, 21 May 2004 17:17
To: 'Access Developers discussion and problem solving'
Subject: [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!

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com