How to Prevent Rounding of Numbers

  • Thread starter Thread starter mike
  • Start date Start date
M

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
 
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
 
Rick said:
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
Click to expand...



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
 
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.
 
Back
Top