Thanks Tracy. What do you guys do for data entry? Do you have your users type the last 4 digits in a separate field or as part of the whole zip? Do you rely on them to enter the - or do you use an imput mask?

Thanks for your help.

Rodd

>We set the display when we print the report:
>
>ag_zip = "99999"
>? IIF(LEN(ALLTRIM(ag_zip)) > 5,TRANSFORM(ag_zip,"@rz 99999-9999"),ag_zip)
>ag_zip = "999991234"
>? IIF(LEN(ALLTRIM(ag_zip)) > 5,TRANSFORM(ag_zip,"@rz 99999-9999"),ag_zip)
>
>
>>Because we deal with so many foreign addresses, we're trying to use input masks for the postal code based on the country. For instance, Canada would have the input mask A9A 9A9.
>>
>>However, I'm stumped as to what to do with US zip codes. A mask of 99999-9999 gives a result of 32771- if the user only enters a 5 digit zip (which we want to allow.) Even if I use the R in the format property, it looks funny on the screen to the user because the dash really isnt' needed unless the last 4 digits are entered.
>>
>>If we use a mask of 99999#9999, we have an entirely new set of problems in that now the - can be substituted with a space or the first of the 4 digit suffix.
>>
>>Is there any way to handle this?
>>
>>Thanks for your help.
>>
>>Rodd