Multiple items form, checking a field?

[drazen]

HI, I have a multiple item form (Event_log) as a subform, listing all activity from the client on the main form. there are hundreds of entries on the Event_log. I am trying to turn the text of the 'event' field blue if the event filed contains the word Invoice. (to find them faster)
I have the code :-

If Me.Event_Details Like "*INVOICE*" Then
    Me.Event_Details.ForeColor = vbBlue
Else
    Me.Event_Details.ForeColor = vbBlack
End If

I think its sound, but where do I put it?

Thanks in advance.

 

[sneuberg]

I assume you have Access 97. If that assumption is wrong and your have Access 2000 or later just use conditional formatting for this.

For Access 97 this is a tricky because the code you got will change all of the records that are in continuous forms. I suggest trying the procedure in the second post of http://www.utteraccess.com/forum/index.php?showtopic=671608

 

[drazen]

I'm using Access 2010, I totally forgot about conditional formatting ( Sorted thanks .