Changing the color of a memo as a query value changes

DavidWIII · January 2014

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 · January 2014

try the onafterdata event of the memo

DavidWIII · January 2014

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.

Changing the color of a memo as a query value changes

Comments

Leave a Comment