How to Prevent Rounding of Numbers

[mike]

Hi all
I've having problem entering numeric data.
I've tried setting the table and form properties to Fixed/General and
Decimal Places to 2 but still the access form keeps rounding the
numbers and same rounded figures get entered in the table.
How to resolve this issue?
There is another field(bounded text box) which displays calculated
value ,and its showing the decimal values properly.Its properties are
set to Fixed and 2 Decimals.

Pls Help
THanks
Mike

 

[Rick B]

What type of field is it? Look at the table design and check the "Field
Size". Is it set to integer, or something that does not support decimal
places?

Rick b

 

[mike]

What type of field is it? Look at the table design and check the "Field
Size". Is it set to integer, or something that does not support decimal
places?

Rick b

The Field looks up the value in a textbox ( ie textbox in the form)
Data type : Number
Field Size : Long Integer
Format :General Number
Decimal Places: 2

It just cant understand whats the problem

 

[Mark]

The problem is that the Long Integer data type is by its very nature capable
of storing only whole numbers. If you want to store decimal values you need
to pick a number type of anything that doesn't contain the word "Integer" in
it.