Information générale
Catégorie:
Codage, syntaxe et commandes
>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????
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement