Access Event for Escaping out of a form
Posted on 2012-09-10
I have an label that displays a certain text when a field value on a bound form is true, and a different text when the value is false . The label works as a toggle. When the label is clicked the fld value turns true and the lable says "On". Clicked again, the field value is false and the label says "Off".
My problem comes when someone hits the Esc key in the middle of updating.
If they click the label when the value is false it goes from "Off" to "On". This is before the form is updated. If they hit the Esc key, the value reverts back to False, but the Label stays "On".
Does anyone know how to trap for the Esc key? Or how to handle the situation?
Any help would be greatly appreciated.