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

[Deb]

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

 

[Jeff Boyce]

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

 

[KARL DEWEY]

In your form set the Format as #.## for the text box.

 

[John Vinson]

In your form set the Format as #.## for the text box.

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]

 

[David PONDA]

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.