Zip Code Format Mask

From: Aaron V <Tinkerist_at_hotmail.com>
Date: Tue, 20 May 2003 21:40:59 GMT
Message-ID: <Lhxya.912355$3D1.519481_at_sccrnsc01>



Hi,

[Quoted] [Quoted]     I'm using Forms 6i and I'm trying to set up a format mask to accept zip [Quoted] [Quoted] codes as 5 digit or 9 digit (99999-9999). I only want the first 5 digits to [Quoted] be required. The last 4 are optional, but I want to have trailing zeros if [Quoted] [Quoted] omitted. I tried FM99999"-"0000 , which works fine if all 9 digits are [Quoted] entered, but with only five entered, it puts leading zeros, instead of [Quoted] 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 [Quoted] have to change the first 9 to a 0). Or if you've encountered this in the [Quoted] past and written a WHEN-VALIDATE-ITEM trigger I'd appreciate a look at it.

Thanks in advance,

AaronV Received on Tue May 20 2003 - 23:40:59 CEST

Original text of this message