Originally Posted 21 September 2016, 10:04 am ESTHi,
For example: I have 2 columns which are both bound.
Column1 contains a value of "1", and the value of column2 is "A".
Now the user enters a value of "2" to column1, and the BeforeColUpdate event assigns a value of "ABC" to column2.
All is OK.
However, moving back to the cell of column1 and pressing ESC reverts the cell back to its original value of "1" (cancels the changes made to the current cell).
I want the value of column2 to also revert back to "A".
There is no event that fires when a cell is restored to its original value. I thought about using the KeyPress event to catch the ESC key, but then I don't know in this event the previous value of column1 because when I press ESC key, it will fire when column1 has the value of "2"
before restoring it to a value of "1".
What should I do?
Thanks in advance.