In a grid, our currencies appear with 4 decimal places. The combination of a R for format and an input mask of 9999999999.99 still displays four decimals. How do I get it to display 2 decimal places only with a currency data type? Some of the fields are read-only, so although the input mask changes to 2 decimal places when you edit, the read-only fields never get the focus, and cannot change.

We have a back-end SQL Server database with SQL pass through generating updatable remote views in code.