I am have a bit of difficulty with the following scenario.

I have a grid on a form. The displayed numeric values in the grid need to be rounded if the user chosen rounding.

I have the control source set to view.field when rounding is off
and ROUND(view.field,2) when rounding is on.

The problem is that when rounding is on, the value in the grid cannot be changed.

I have tried changing the sparse and changing the controlsource on the fly (but this only works when the grid loses focus).

Is there a way I can use the view.field as the control source, display the ROUNDED value, and still be able to edit the field?