Strange. Try changing it to a Single or Double.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Mark Kubicki" wrote:

i have a field [SortOrder] which is
data type - number
field size - decimal
format - standard
precision - 8
decimal places - 2

however, whn in datasheet view, if if enter a numer (let's say; 150.10,
Access immediately changes it to 150.00

Sorry to say, i give up, could someone tell me what i am doing wrong?
-mark

(when i first created this atble, the field [SortOrder] had an incorrect
data type of text; which was subsequently changed to number after a small
amount of data had already been entered...)


.