Currency field

[sassenach]

Hi,

I am working on a project, making a company inventory, sales, orders, etc.
When i am in Forms, i have a form called Orders. There i can fill out a customer order with a product subform.
The problem i am having is towards the end where I get to put the amout received from the customer after the customer received his/her product.
In that field, it is obviously currency, default is israeli shekels and the decimal is set to 2. When I try to enter the amount with two decimal, such as 1,894.02, it shows it as 1,894.00. Meaning the decimal area, it doesnt show as i put in. I tried checking if there is rounding off, but dont know how to do that.
Any suggestions???

 

[jeremie_ingram]

Try setting the decmile to AUTO and not 2. This may eliminate the problem sine the field is set to currency it should default to 2.

 

[sassenach]

orgianally, it was set to Auto, and since i didnt work, i changed it to 2 and still didnt work.
any other suggestions?
is it possibe for someone to look over my project?

 

[Idjit]

Make sure you set the decimal properties for this field both on the form and in the underlying table.