Hello
I want to format a social number like 756.6523.5720.40
I tried to set the format propertie of the field to ####,####,####,## and to 000,0000,0000,00 but both does not work as expected!
How can I format a number like shown above.
Regards
Stef
What type of field do you have? Integer or number?
I tried to format both by setting the property like your example, but it also doesn’t work for me. Is it possible for you to take a text field and format the value by an onDataChange function?
Regards
Thomas
my guess is that you need to use a mask so that ####,####,####,#### and so on the , is really not seen as a decimal or grouping symbol but more as a literal (which it kind of is)
Sorry for my late reply. I was in holidays.
The Format ####,####,####,#### is not what i want! It looks like it is not possible to format the number automaticly like 756.6523.5720.40
I think i have to format the number manually onDataChange.
Regrads
Stefan
If you store it as a string, then this mask:
###.####.####.##
should work fine (it is really not a number anyway…)
You can’t use that on real numbers at the moment, or you have to place a converter between it…
That converts from a number DB value to a String (and then use the above mask)
and converts from the String to the number db value again (but this is already pretty automatic)