Spell Check not dirtying record

[Dave Reardon]

I read with interest an earlier post along similar lines to what I am about
to ask. I have a database designed for writing student reports. All works
reasonably well as far as writing (which I can get to change the date
modified field in each record etc, using the after update event) is
concerned. However, when I run the spell checker, and click on change, no
matter what I do, it doesn't seem to want to update the date modified on that
record. It will correct any spelling mistakes and move on. I have set events
to trigger on after update, on dirty and on change. Of course, if the record
is manually edited the trigger works fine, since the record ha been dirtied
by the user rather than programmatically. Any suggestions greatly
appreciated. I am using Access 2007 but the database in question is in 2000
format for backwards compatibility.

Dave

 

[Douglas J. Steele]

Which AfterUpdate event are you using: the control's or the form's?

 

[Dave Reardon]

Hi Doug

That of the control, so that after update, set value of (separate control)
DateTime = Now()

Dave

 

[Douglas J. Steele]

I think your only choice would be to compare the field's Value to its
OldValue.

 

[Dave Reardon]

Thanks Doug

The only problem with that is if it is a spelling mistake such as a
transposition error, then the comment length might be the same. It is a memo
field into which users enter text.

Dave

 

[Douglas J. Steele]

I said to compare .Value property to the .OldValue property: the actual
content of the fields.

 

[Dave Reardon]

Forgive my stupidity, Doug. Absolutely right and it works a treat. I have set
the before update event to compare .OldValue with .Value and if not the same,
set the value of the date modified to now(). Many thanks again.

Dave