Numeric Formatting Problem
450042May 23 2006 — edited May 23 2006Version 2.0
I have four fields on a page that display costs. See http://i4.tinypic.com/10gjlo6.jpg
I'm having problems trying to format these fields to 9,999,999,990.00 type of format. YES I've done the obvious of setting the Format Mask on each item. The result is what I show in the above jpg. All four fields do have the Read Only set to Always. Setting it to Never has no effect. The Display As is set to Text on all the fields.
The calculations for these fields WERE on this page, but I moved them to another page to try to get the formatting to work. I have not had any luck.
The calculations are in an On Submit - After Computations and Validations process. The values are written to the table and the data types for all four columns are numbers. As I said the Format Mask is set on all these fields, but they are not formatted.
Can someone help me with this? Is there any other information needed?
Thanks,
Joe