>Hi Cetin-
>
>Your suggestion is a good start -- I need to pass in the *name* of the controlsource to mySetColor, rather than the value. I have tried numerous combinations of quotes etc with no luck. Any suggestions?
>
>Carlie
Carlie,
Reading your post again maybe I misguide you. You say you tried combinations of quotes. Here is another sample that uses "old" varread() to get active cell :
this.SetAll("DynamicBackColor", ;
"iif(recno(this.recordsource) = thisform.nCurRec or " +;
"this.activecolumn > 0 and this.columns(this.activecolumn).controlsource "+;
"= lower(this.recordsource+'.'+varread()), 256^2-1,256^3-1)","Column")
Cetin