[AccessD] Addresses

Jürgen:

I'm curious ... did the guidelines change? When I ran a mail and file room a
few years ago, we were informed by Canada Post that the postal code was
required to be on a line by itself.

NAME
ADDRESS
MUNICIPALITY PC
Z9Z 9Z9

Regards,
Bob Gajewski


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jürgen Welz
Sent: Friday, May 21, 2004 19:53
To: accessd at databaseadvisors.com
Subject: RE: [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=htt
p://hotmail.com/enca&HL=Market_MSNIS_Taglines

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