Is Dirty for a field?

[Chris Cairns]

Is there a way to determine if the current field is dirty? I need to know
if a user has changed the value in the current field. That way if they press
the escape key I will allow access to undo the field but if it is not dirty
then I want to display a message to the user asking them to answer yes or no
to losing all of the changes to the current record which is what happens
when you press escape and the current field has not been changed.

 

[Anthony]

IF YOUR MONITOR IS DERTY THEN CLEAN IT WITH WINDEX

 

[Stefan Hoffmann]

hi Chris,

Is there a way to determine if the current field is dirty? I need to know
if a user has changed the value in the current field.

Controls like TextBox have a .Dirty property.

DAO fields have a .OriginalValue property, so by comparing
..OriginalValue <> .Value gives you your "dirty" value.


mfG
--> stefan <--

 

[Marshall Barton]

Is there a way to determine if the current field is dirty? I need to know
if a user has changed the value in the current field. That way if they press
the escape key I will allow access to undo the field but if it is not dirty
then I want to display a message to the user asking them to answer yes or no
to losing all of the changes to the current record which is what happens
when you press escape and the current field has not been changed.

The AfterUpdate event only fires if the value was edited.
You can use this to simulate a dirty property for the
control.

If the control is bound to a record source field, you can
check the control's OldValue property to see if it's
different from the Value property.

Why do you think you need to use a non-standard UI?