Form Property - Form.Dirty Question - Access 2000 vs 2003

[Rick Roubos]

Background:
I've written an application that is running on a few machines. The majority
of the machines have Access 2000 installed with the remainder using Access
2003.


I used the Microsoft suggested method (method 2 of the Knowledge Base
Article
http://support.microsoft.com/default.aspx?scid=kb;en-us;210334&Product=acc)
to detect when a form is being edited based on the [Form].[Dirty] value. I
use it to control save, undo and various other buttons.

Everything works fine in Access 2000 but it does not work in Access 2003.
When I open the application (still in Access 2000 format) in Access 2003 and
look at the textbox with the control source =[Form].[Dirty] &
EditModeChange([Form]) during a run it shows #Name. I changed the control
source to =[Form].[Dirty] and it gave the same value. This value is not
allowed on forms in 2003? Any alternate value I can use?


As an aside, the form's OnDirty event does not fire after a bound control on
a bound form has changed, even after focus has moved off of that control.
Is this the standard behaviour for this event, to do nothing, ever?

 

[Allen Browne]

That article has never worked reliably, so it is not surprising that you
have run into problems after converting.

Forms now have a Dirty event and an Undo event. Use the Dirty event to
determine when the form is being dirtied.