How to detect if the edited row remains unaltered within the AfterEdit event

How to detect if the edited row remains unaltered within the AfterEdit event

Posted by: Calvin.Craig on 28 September 2018, 8:04 pm EST

• 

  Calvin.Craig

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 28 September 2018, 8:04 pm EST

  In the AfterEdit event, how does one detect if a user’s modifications haven’t actually changed underlying record?

  A user could append a few characters to a cell’s value and then immediately backspace to delete them. If the user then presses Tab to advance to the next cell, the AfterEdit event is triggered. At this point, since the record hasn’t been changed yet, I don’t want run the code in the AfterEdit event handler.

• 

  jitender.yadav

  

  • Post Options:
  • Link
    Copy

  Posted 1 October 2018, 12:56 am EST

  Hi,

  You should use CellChanged event instead of AfterEdit event. CellChanged is fired only when the cell value is actually changed.

  Regards,
  
  Jitender