Input Masks

[Guest]

Hi There

When designing tables and you put a input mask for Canandian Postal Code, it
works well, but we also do business in USA and need an input mask for the Zip
Code. Is there a way when you type USA, the input mask for zip code is
activated and when you type Canada the input mask for postal code is
activated. This been in the same table.

Any help or suggestions would be appreaciated.

Thanking you.

 

[Al Camp]

Use the AfterUpdate event of Country...(use your own masks)
If Country = "USA" Then
Zip.InputMask = "99999-9999"
Elseif Country <> "USA"
Zip.InputMask = "999-999"
End If
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions