Re: Zip Code Format Mask

"Aaron V" <Tinkerist_at_hotmail.com> wrote
> Hi,
>
> I'm using Forms 6i and I'm trying to set up a format mask to accept
zip
> codes as 5 digit or 9 digit (99999-9999). I only want the first 5 digits
to
> be required. The last 4 are optional, but I want to have trailing zeros
if
> omitted. I tried FM99999"-"0000 , which works fine if all 9 digits are
> entered, but with only five entered, it puts leading zeros, instead of
> trailing, and because of fill mode, allows less than the five digits
> required. Oh, does anyone know if zip codes ever have leading zero(s)?
(I'd
> have to change the first 9 to a 0). Or if you've encountered this in the
> past and written a WHEN-VALIDATE-ITEM trigger I'd appreciate a look at it.
>
> Thanks in advance,
>
Lots of states have zips that start with '0%'. You'll be safest if you make it a character field. Using a character field also makes the formatting easier. Received on Wed May 21 2003 - 00:35:28 CEST