Combo Box is rounding values up..

[richardcasci]

I have three combo boxes linking to three different forms. One form for each box.

Each form has the numbers from 1 through 10. However, I have also included quarter values so they look like this... 1, 1.25, 1.50, 1.75, 2....

Two of my combo boxes are doing fine and allow you to select each number as it is in the drop down and listed on the form.

One box continues to round whatever value I pick. So if I pick 1.75, it displays 2 after 1.75 is selected.....

I am using Access 2010.

I cannot find ANY difference in the three forms or three combo boxes.

 

[spikepl]

bound to an integer/long field?

 

[richardcasci]

bound to an integer/long field?

No, I actually made them all currency because I could not get anything else to work.

 

[Richard McCabe]

Check the specific field the combo box is updating. If the number of decimal places is set to 0, the values will be rounded. 1.75 is rounded to 2... what happens if you choose 1.25?
Richard McCabe

 

[richardcasci]

Nevermind...

One of the forms I was using labeled the fields as TEXT instead of number or currency.

I corrected that and now I am in business....


Thanks

 

[Richard McCabe]

You caught it a lot quicker than i did when I did the same thing!!!

Rich McCabe