form text box does not take decimal value

[Jaik]

In the form, I have 3 columns let users put value in it. Debit type(text), Debit Amount(Number), DebitDate(Text).
Everything works great, but If I try to type decimal numbers like 54.25 in the Debit Amount textbox, it will display only 54.
Is there any way to display the full decimal number in the text box?




Thank you

[ItsMe]

It sounds like your textbox control is bound to a field in a table that is of Data Type number and size Integer or Long Integer. Maybe a Double is a more appropriate Size.

Also, get familiar with Format. You can Format stuff so it looks a certain way. However, Format is just a version of the underlying data and Format does not affect the value of the underlying data.

[ssanfu]

In the table, what is the data type for the field "Debit Amount"? Integer, Long Integer, Single, Double?????

I've got to get up earlier!! ItsMe beat me again... Arg


BTW, do you really have spaces in the field names??? Shouldn't use spaces in object names