After Update Event

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I thought I entered the following correct, but it doesn't seem to be working.
Can someone tell me if what I'm trying to do is possible.

I have a very simble two field table. Say one field is words. When I print
a report of all the words, if one of the words has ever been modified, I want
to change the font color of the word when the print reports. I tried using
the field.tag property. I set the tag default to the text "unchanged". Then
on after update event, I set the tag to "changed".

Then in the report property format, if the tag was equal to "changed", the
font would be red. I know if the field is the focus I can't change the tag
property. Am I even close to being on the right track?

Am I correct in thinking that the tag property is unique for each record?

Here is my code...


Private Sub Starts_with_AfterUpdate()
Word.Tag = "changed"
End Sub

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Word.Tag = "unchanged" Then
Word.ForeColor = 0
Else
Word.ForeColor = 255
End If

End Sub
 
Sorry -
the .Tag property is not unique to the record; it applies to the field
in all records.
Perhaps you can add a 3rd field to your table, to store the "changed" state.
A yes/no field would work.
 
Back
Top