Hi all,
I have a numeric field with this display pattern: zzz9
How can I set it to force the user insert only 5 integers (not more, not less), and that not cut initial zero (for example, now if I write 01234 it display 1234).
Thanks in advance.
Luigi
You sent this a long time ago - way before I joined up here, so you've probably already figured it out. But in case you haven't, the easiest way I found around this was to create a Text (not Numeric) field and in the Object Field tab, set the 'Display Pattern' to 99999 (for your 5 integer requirement).
Then go to the Value Tab, and in the 'Validation Pattern', type 99999
Check the Validation Pattern Message checkbox
Enter a Validation Pattern Message in the field provided (eg. "5 characters must be entered") or whatever you want.
All of this will force it to require a numeric value even though it's a text field, and the '99999' will force it to be a 5 number field that will accept leading zeroes.
Hope that helps (if it's not too late),
Peta
from way... underground at Parkes - central West NSW - Australia