PDA

View Full Version : Decimal Places


mcleyn
Oct 1, 2010, 07:40 AM
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
Oct 1, 2010, 03:10 PM
I'll bet the datatype is set to Integer. Change the datatype in the table to Currency.

mcleyn
Oct 8, 2010, 10:35 AM
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.