decimal format of zz9.99 strips trailing zeroes

[Former Community Member]

A numeric field with all pattern parameters set to zz9.99 when form is filled in Reader, trailing zeros are stripped off, e.g. 123.00 becomes 123. I've tried changing the binding data format to float from decimal and still no luck. Any ideas?

[Former Community Member]

You have to set the field display pattern to show the formatted value.

[Former Community Member]

I have set the field display pattern, the edit pattern, the data pattern, and the validation pattern all the same with the same result.

[Former Community Member]

The only ones you need are the display and edit patterns. I tried putting a pattern of zz9.99 into a numeric field object and got the correct format when I entered 123 into the field using Reader. It reformatted it into 123.00



When you dont see the pattern applied, it usually means that you have enter in data that has violated the pattern you have specified in Designer. So if you enter 1000 into this field, no pattern is applied since it is greater than 999.99 (the max).



Also, check the locale, the decimal digit might be messing up the pattern

[Former Community Member]

Thanks, it looks like the data pattern was interfering somehow. When I got rid of it and the validation pattern as you suggested, the form works fine. Many thanks.