I don't want currency to round in a form

[Guest]

In a form I'm using for products, I am trying to get the price box to
automatically update depending on the product I choose from a combo box. It
is working except for the fact that the Price is rounded after I choose a
product. The field on the table is currency as well on the form. Why is it
rounding and how can I get it to put the exact price?

 

[Guest]

Never Mind...I figured it out!

 

[Dirk Goldgar]

In a form I'm using for products, I am trying to get the price box to
automatically update depending on the product I choose from a combo
box. It is working except for the fact that the Price is rounded
after I choose a product. The field on the table is currency as well
on the form. Why is it rounding and how can I get it to put the
exact price?

Rounded to how many decimal places? Do you mean that it is rounded to a
whole number? If so, check the field in the table -- the table to which
the form is bound, and the field in that table to which the combo box is
bound -- to make sure that its *Data Type* is Currency, not just its
Format.

 

[Guest]

Thank you, that had been driving me mad for days, couldnt understand why
access had taken it upon itself to round them for me!!! Your a life saver (my
computers life that is)