[mcleyn]

Hi there,

I have a form with a text book that is bound to a table. I would like to keep two decimal places when I enter a number inside the textbox. For example, $47.12
I have set the properties for the table and the textbox to, format: currency and decimal places: 2.

However, when I enter a number into the textbox, it always rounds and gives me zeros, instead of the actual number. For instance, if I enter $47.12, it automatically swithches to $47.00

What seems to be the issue?

[ScottGem]

I'll bet the datatype is set to Integer. Change the datatype in the table to Currency.

[mcleyn]

I'll bet the datatype is set to Integer. Change the datatype in the table to Currency.

Thank you very much. That was the exact problem.