Sami By defining a field as NUMERIC (9,2) I usually automatically get the trailing zeros. Don't you?
SET VAR vTemp NUMERIC (9,2) SET VAR vTemp = 2.2 SHOW VAR: vTemp = 2.20 David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, September 27, 2005 2:08 PM Subject: [RBG7-L] - Numeric Display format > I would like to set a FORMAT Mask on a NUMERIC (14,2) field on a form, so > that the trailing decimal zero(s) will display. In other words, if the > number is 123456 then I want it to display 123456.00. If it is 12345.6 then > I want it to display 12345.60. > > I've tried every FORMAT MASK I can think of with no success. > > Short of changing the data type to CURRENCY, can this be done? > > Thanks! > Sami Aaron > Software Management Specialists > 913-915-1971 > [EMAIL PROTECTED] > > > >
