decimal format of zz9.99 strips trailing zeroes | Community
Skip to main content
March 22, 2005

decimal format of zz9.99 strips trailing zeroes

  • March 22, 2005
  • 4 replies
  • 4871 views
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?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

March 22, 2005
You have to set the field display pattern to show the formatted value.
March 22, 2005
I have set the field display pattern, the edit pattern, the data pattern, and the validation pattern all the same with the same result.
March 22, 2005
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
March 22, 2005
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.