How to NOT Round decimals....?

[Netraven]

I'm trying to create a form view of a table for data entry, and I have a field for gram weight, but it keeps rounding my value. I try to enter any decimal value and it will round it to the nearest integer. I have both the table field and the form field set to 2 places for decimals and have tried changing the format from long integer, to double, to Single, to decimal... some round up. Some round down. But nothing lets the value stay as I enter it. I'm aware I can change it to a text field, but I need to perform a calculation on the value I enter.

Help me Obiwan... You're my only hope!

 

[Brianwarnock]

Can we be clear here. After changing both the Table and the Form to Double with 2 places of decimals you did reinput the data.

Brian

 

[boblarson]

Restated in a different way, as Brian, so wisely, said - If you had numbers in a table which was once integers, how would you expect the decimal places to come back to numbers that were now integers? You would have to re-enter them AFTER the change of datatype.

 

[Netraven]

Yes, I did re-enter the data after changing the data types.

Even with it as Double with 2 decimal places, if I type in 19.60, it will show 20.00

 

[Netraven]

I knew it was something stupid... I changed both fields to "Standard", and the Table field is set to Double. But if I change the Form Field to General Number or Fixed, it doesn't work.

Thanks anyway. I now return you to your regularly scheduled Forum!

 

[homeflash]

I had the same problem, but I found out that it should be simple

on design view of your table,

You must change the number field format to "Decimal", and "scale" from 0 to 2 and then whenever you enter will not to be rounded off!

 

[sheesh.katie]

I am having the same problem... Figured out where Decimal was, but on the scale, it will not let me enter "0 to 2" or "0-2". What am I doing wrong?

 

[sheesh.katie]

Just entered two and seems to work fine, thanks anyway.