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

  • Thread starter Thread starter Rick Roubos
  • Start date Start date
R

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?
 
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.
 
Back
Top