Re: Zip Code Format Mask

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 23 May 2003 01:18:13 -0700
Message-ID: <1a8fec49.0305230018.20f6b45a_at_posting.google.com>


Remember that there are other countries in the world apart from the usa. Almost all of them havesome kind of geographical / postal location system and none of them at all are compatible with the usa system.

[Quoted] A good software developer / designer will not restrict them to such a small percentage of the world market!

ETA "Aaron V" <Tinkerist_at_hotmail.com> wrote in message news:<Lhxya.912355$3D1.519481_at_sccrnsc01>...
> 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,
>
> AaronV
Received on Fri May 23 2003 - 10:18:13 CEST

Original text of this message