format of number field

[Hans Nieuwenhuis]

Hi,

I have a database field of type number so it can contain any number with any decimals.

How can I make sure that what you see in the form field is exactly what is in the database ?

For instance if I use no format on the form field and I enter a value of 0,01234567 and I leave the field it shows 0,012
but in the database the value of .0123456699999999996 is stored.
I want to see the database value in the field.

Regards,

[Andrei Costescu]

A format (in locale preferences or on the field) similar to "#.####################" would do the trick.