decimal values in edit form

[Sharuk]

Hi Community,

I'm having a form in which one is float datatype(sql db connection) where i'm checking for number shouldn't have more than 2 decimals and i'm able to do that and edit the data in edit form.

but when user tries to save 25.00 or 50.00 in newform and while editing the data it is getting back in 25 / 50 without .00 but it is not the same case for 25.55 or 35.45.

how can we handle this ? 

[RandyHayes]

@Sharuk 

Change the Default property of your control, if it is a TextInput, or the Text property if it is a label to:

   Text(<yourcurrentformulahere>, "#.00")

I hope this is helpful for you.