[AccessD] Addresses

Arthur;
Travel - expand your world - do some web surfing.  Many web sites list
the address information in a preferred/required format.  Found this from
"singapore address" with google

NORBAR SOUTH EAST ASIA
9 Raffles Place
#27-01
Republic Plaza
SINGAPORE 048619 

-am I being too simplistic?
Damn Canadians - had to put that insane postal code on a separate line
from province > bigger labels (I'm Canadian so I can criticize!)
Have a good week-end.


> -----Original Message-----
> From: Arthur Fuller [mailto:artful at rogers.com] 
> Sent: Friday, May 21, 2004 5:17 PM
> 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
>