[AccessD] Addresses

Canada post guidlines stipulate City, province abbreviation and postal code 
appear on a single line.  The prefer a fixed width font, no punctuation 
except where it is part of an official name and one space between words, two 
spaces before the postal code.  All my Canadian addressing adheres to this 
standard.

I would never combine these into a single storage field.  I split these bits 
of information in order to be able to find/sort/filter.  I can see where 
allowing a user to modify a particular combination/order of field data into 
a single address would be useful if you cannot arrive at an algorithm that 
handles all scenarios.  Fortunately I only use Word for automation for 
anything requiring addressing and I have few countries to handle so I have 
not had to resort to a memo field for this data.

Ciao
Jürgen Welz
Edmonton, Alberta
jwelz at hotmail.com





>From: "Martin Kahelin" <mkahelin at gorskibulk.com>
>
>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

_________________________________________________________________
MSN Premium: Up to 11 personalized e-mail addresses and 2 months FREE*   
http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines