John Baird
Coatesville, Pennsylvania, United States
General information
Category:
Forms & Form designer
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only