>Why does the Currency field type carry 4 decimals, and if it is used in a form textbox or report control, how should it be formatted so it only displays 2 decimals?
>
>Seems like a bother to me. Why not just use N(10,2)?
I think it only displays 2 decimals anyway. Also nothing prevents you from using NUMERIC for monetary values.
You can also look at SET DECIMALS command.
If it's not broken, fix it until it is.
My Blog