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]
 

Reply via email to