decimal places

[Megatron-Lives]

What function does the property "Decimal Places" serve?

I have it set to auto, enter 4.75, it rounds to 5

I have it set to 1 decimal, I enter 4.75, it rounds to 5

I have it set at 2 decimals, and enter 4.75, and it rounds it to 5

How do I actually display the decimals?

I don't care about Datasheet view, but my asp tables need to show the decimals.

 

[jobb]

to show the decimals, try changing the Format to "Fixed" with 2 under decimal places

 

[Megatron-Lives]

that shows decimal places, but still rounds

I enter 4.75, it enters 5.00

 

[Dugantrain]

By default, your numerical data types will be Long Integer which only allows for Integers. Change your Data Type to either Single or Double.

 

[Megatron-Lives]

sweet, thanks...