Re: Oh, Canada! Mailing address issues.
- From: "Debra Farnham" <dfarnhamNOSPAM@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 6 Sep 2005 21:41:30 -0400
Hi Stephanie
I guess as the saying goes "I am Canadian"
Hi Stephanie
Yes .... Ottawa is a City, ON can be considered a state (however us
northerners call it a Province - Ontario to be exact) and the K1A 0B1
(letter number letter, number letter number) can be considered a zip
code/postal code.
Your idea for showing the new label is a good one but not really necessary
unless you are using an input mask for the US postal code formats which are
five numbers hyphen four numbers which really makes it more of a data entry
problem than a label problem. It is called a postal code, the same as what
you appear to be using now.
I believe I have some code kicking around here somewhere which will handle
the formatting of either a Canadian or American postal code on the lostfocus
event of the form textbox if you would like it. I live in a bordertown and
it is necessary in nearly every application I build.
I hope this helps
Debra
"Stephanie" <Stephanie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:68CCCF54-8EBE-429C-9689-B1653E1A424D@xxxxxxxxxxxxxxxx
> Greetings! I have a nifty form for entering Contacts and their addresses.
> My form is adaptable for primary and secondary addresses, by chosing the
> appropriate flag.
> Now I need to modify my setup to include Canada. I've included my mailing
> label query to show field names.
>
> The post office shows Canadian addresses as such:
> MS HELEN SAUNDERS
> 1010 CLEAR STREET
> OTTAWA ON K1A 0B1
> CANADA
>
> I'd appreciate any suggestions to handle:
> OTTAWA ON K1A 0B1
> CANADA
>
> Could I consider OTTAWA as a City in my format, ON as a State in my
format?
> I guess I could have a field for Country that defaults to United States,
but
> if Canada is selected, have a field visible for K1A 0B1... The new label
> query scares me. One step at a time! I'd appreciate any suggestions for
> incorporating Canada into my address form. Thanks.
>
> My query:
> Nz(c1.ContactNickName,c1.ContactFirstName) & " " & c1.ContactLastName AS
> ContactName, IIf([AddressFlag]=1,c1.MailingAddress1 & ",
> "+c1.OptAddress1,c1.MailingAddress2 & ", "+c1.OptAddress2) AS Address,
> IIf([AddressFlag]=1,c1.City1,c1.City2) AS City,
> IIf([AddressFlag]=1,UCase(c1.StateOrProvince1),UCase(c1.StateOrProvince2))
AS
> State, IIf([AddressFlag]=1,c1.PostalCode1,c1.PostalCode2) AS PostalCode,
> c1.SignificantOtherID, c1.Newsletter
>
>
>
.
- Follow-Ups:
- Re: Oh, Canada! Mailing address issues.
- From: Stephanie
- Re: Oh, Canada! Mailing address issues.
- References:
- Oh, Canada! Mailing address issues.
- From: Stephanie
- Oh, Canada! Mailing address issues.
- Prev by Date: Re: Oh, Canada! Mailing address issues.
- Next by Date: Re: Oh, Canada! Mailing address issues.
- Previous by thread: Re: Oh, Canada! Mailing address issues.
- Next by thread: Re: Oh, Canada! Mailing address issues.
- Index(es):
Relevant Pages
|
