>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.