Stop Rounding!

[summer]

I have 2 cells of data that are driven from a combo box. The table in which the data for the combo box comes from shows the numbers correctly (not rounded), but when I select something in the combo box, it is delivering the results rounded up.

My properties are set as:
Field Size: Double (I've also tried Integer/Long Integer)
Format: Fixed (I've also tried Standard)
Decimal: 2

How do I get it to stop rounding up? I've looked up past topics on this, but nothing has helped!

 

[kavarin]

As sad as it sounds..I have had that same problem...and only changing the field to TEXT has worked for me. I had the problem with percentages...it kept rounding up, but having it text didn't make a difference for me..so I went with it. STILL looking for the proper way

 

[Jack Cowley]

Hmmm. I have the numbers set to Double, Fixed and 2 Decimals in the table that the combo reads from. The fields that the combo saves the data to is Double, Fixed and 2 decimal places. The combo shows the numbers correctly and the fields show the data correctly after they are updated by the combo box....

 

[summer]

Well, the weird thing is, is that it was working fine when I first created it, then the next day, it started to round the numbers!