>the funny thing about this is if i use 7 nines before the decimal it rounds but if i use 6 it does not round, i have changed the max length accordingly. this must be a microsoft "enhancement"
The max length is only relevant for character data. Is your textbox bound to a table field?
--sb--