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

Chris,

You don't say what verison of VFP you are using. If it is 5.0 then dump the format and inputmask on the textboxes in the column and set those proeprties for the column itself.

If you are using 3.0 leave the properties set for the control in the column and set the column.sparse property to .F.