Postal Codes & Zip Codes

[Joel]

Hey, I'm brand new here... I mean this is only the second
day that I'm trying to configure a template to fit my
needs. I'm starting a home business & I'm using a template
that I can enter my clients address.

What I can't figure out is how can I modify the postal
code option to accept both Canadian/US codes?

I hope someone can help me out or offer a better solution.

Thanks,
Joel

 

[John Vinson]

What I can't figure out is how can I modify the postal
code option to accept both Canadian/US codes?

You can't.

Simply remove the Input Mask and Format properties of the field.
They're not flexible enough to allow both formats; you'll just need to
type carefully (or write some rather advanced VBA code to determine
which country is desired and vet the post code accordingly).

 

[Kevin]

What I can't figure out is how can I modify the postal

You can't.

Simply remove the Input Mask and Format properties of the field.
They're not flexible enough to allow both formats...

John W. Vinson[MVP]

Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John,

This raises an important issue. It seems input masks in
Borland's Paradox were much more flexible. Haven't
developers been beating on Microsoft to improve this
feature?

Kevin Sprinkel
Becker & Frondorf

 

[John Vinson]

John,

This raises an important issue. It seems input masks in
Borland's Paradox were much more flexible. Haven't
developers been beating on Microsoft to improve this
feature?

Well, I haven't - I'm no fan of input masks generally! But I can see
that a more flexible feature might be of some advantage. Maybe a new
thread "Are Input Masks in need of improvement?" might be of
interest... care to start one?

 

[John Nurick]

What I can't figure out is how can I modify the postal
code option to accept both Canadian/US codes?

As others have said, the input mask can't do this. There's a VBA
function here http://www.mvps.org/access/modules/mdl0063.htm for
validating various kinds of data; if you use it with this pattern
"(?:\d{5}(?:-\d{4})?)|(?:[A-Z]\d[A-Z] \d[A-Z]\d)" it should accept US or
Canadian postal codes (but will of course reject most other countries'.)