Changing the color of a memo as a query value changes

DavidWIII

The master data band displays rows from a query. One of the values is a client #. There can be a single or multiple rows for a client #. I would like to change the color of the row (each memo) when the client # changes. The client # is not the group heading. I know how to alternate colors on each row.
I???ve tried some code:

var
  clienthold: String;    
begin                                                       
  if clienthold <> MemoClient.lines.text then begin //MemoClient contains the client #                                                                                 
       clienthold:= MemoClient.lines.text;
       Memo2.Color := clRed;  
  end;
end;

Assuming that code works, in what event should I place it?
Is that the wrong approach? Any suggestions?
The report is attached.
Thanks

gordk

try the onafterdata event of the memo

DavidWIII

I had tried the onafterdata event of the memo but had a flaw in my logic. I now have the code setting the color back to its
original when it changes again. I also had to deal with the first row. It's easier to get the code right once you've decided where to put it.
I got it now.
Thanks.

Edit: The onafterdata event was the place to put it.