data entered in access table displays as a rounded up or rounded d

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a table created to log labor hours the data either rounds up (7.5 rounds
to 8) or rounds down (4.5 rounds down to 4). I have the decimals set to 2
places. How can I fix this
 
Deb

Display (i.e., formatting) is not the same as data type (e.g., Integer).

Is there a chance the underlying field's data type is Integer? Integers are
whole numbers, no matter how you wish to display it...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
In your form set the Format as #.## for the text box.
Click to expand...

Also check the datatype of the field. If it's the default Long Integer
type of Number, then it HAS no decimal places - integers are whole
numbers by definition. Change it to Float or Double if that's the
case.

John W. Vinson[MVP]
 
Hi Deb,
just choose in design mode, the Field zise of your table field to Reel or
Double; and change Format to General Number and set your Decimal to 2.
 
Back
Top