Multiple Input Masks?

[Question Boy]

Is it possible to have a control with multiple Input Masks?

One example is the fact that we have both Canadian and American clients so
in the Zip/Postal Code control I need to be able to accept both Candian
Postal Codes as well as American Zip Codes.

How would one normally address this type of situation?

Thank you as always for the help and insight!!!

QB

 

[Linq Adams via AccessMonster.com]

Rather than multiple Input Masks, I suspect the way to do this is to validate
the Zip Code/Postal Code in the textbox BeforeUpdate event , depending on
where the address resides. This necessitates having some way, from data
entered, to determine which country you're dealing with.

Personally, I'd accept the little bit of extra overhead and have two fields,
one for Zip Code and one for Postal Code. It'd make things easier all around.

 

[Douglas J. Steele]

Rather than multiple Input Masks, I suspect the way to do this is to
validate
the Zip Code/Postal Code in the textbox BeforeUpdate event , depending on
where the address resides. This necessitates having some way, from data
entered, to determine which country you're dealing with.

I would think that it would be possible to dynamically change the InputMask
property based on the value in the Country text box.

Personally, I'd accept the little bit of extra overhead and have two
fields,
one for Zip Code and one for Postal Code. It'd make things easier all
around.

Are you suggesting separate fields in the table? Not sure I'd agree with
that...