General information
Category:
Coding, syntax & commands
>Hi Ed,
>
>WOW! Thanks. I wasn't even going to try to format for the Canadian zips yet. My old mask was '99999-9999' and that didn't allow for the alpha in the Canadian zips, so they couldn't enter them. I didn't know the actual format of the Canadian zip anyway - 'til now thanks to you. This does muddy the waters slightly though: not all US zips will have 9 digits, some will be just 5. Hence I can't arbitrarily use the !9!9!9 mask if less then 9 digits. Maybe IF LEN(RTRIM(zip_code)) = 5 OR LEN(RTRIM(zip_code)) = 9 US Format ELSE Canadian format.
>
>Thanks again. Have a nice day. Don't let the Love Bug Bite.
>
>Regards,
>
>Paige
Just a thought. Can you disable the zip field until State/Province is entered and then determine the proper mask based upon that????
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only