decimal format of zz9.99 strips trailing zeroes

[이전 커뮤니티 멤버]

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?

[이전 커뮤니티 멤버]

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

[이전 커뮤니티 멤버]

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

[이전 커뮤니티 멤버]

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

[이전 커뮤니티 멤버]

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.