Decimal Places In Table/Form

[thabounceisback]

I am afraid that my problem is infuriatingly simple, but I cannot seem to fix it.

I have a table and a form which use a field named "Hours". Originally, this field was set-up to round the decimal place. However, I need 2 decimal places now. I have changed the number of dceimal places in both the table and the field on the form. I have tried change the number type from integer to other types of numbers. I cannot get the table or the form to stop rounding the decimal.

What am I missing? Do I have to start all over because I made the mistake when I first set up the database?

 

[ghudson]

Try the "Double" field size in the table design and set the decimal places to Auto. Round to two digits in your forms/reports where display really matters.

 

[thabounceisback]

Try the "Double" field size in the table design and set the decimal places to Auto. Round to two digits in your forms/reports where display really matters.

Thank you.