formatting to 2 decimal places in a form

[dbh139]

I am trying to force 2 decimal places on an input in a form, I keep changing every property I can find to 2 decimal places, however it continues to round it to a whole number. . . where is the property that controls this?

 

[Cortici]

Hi dbh139,

Go to the table where this number ends up, and change the field size for that field to 'decimal' and change scale to "2". This should truncate your users input to 2 decimal places to the right of the decimal.

HTH,