Rounding numbers up - only in XP? (1 Viewer)

[Numpty]

I am currently developing a database in Access 2000 and on a Win98 OS. I recently installed the database onto a laptop which has the same version of access installed but has a WinXP OS. I noticed that a field which hold numbers was being rounded up - 37.5 became 38.

This had not happened during development and no changes were made when it was installed onto the WinXP machine.

Has anyone else come across this, if so is there any way to stop it from happening.

Alos does it happen on any other platforms?

 

[dcx693]

Are you sure the numbers were actually being rounded up, and not just displayed that way?

 

[Numpty]

No, my fault dcx. It was doing this in 98 but I must not have checked the field properties properly. I've changed it around now to stop the rounding.