>*--In debugger entire column is correct color including all rows >WITH this.pgfprofile.pagpolicy.policygrid > FOR nColumnID = 1 TO .columncount > colorvalue = thisform.getpolicycolor(.recordsource,.columns(nColumnID).controlsource) > .Columns(nColumnID).dynamicbackcolor = colorvalue > *--ColorValue = RGB(255,255,0) > *--Column dynamicbackcolor property is same as colorvalue > *--but it is set for the column and includes all of the rows > ENDFOR >ENDWITH >>2nd example:
>*--This one has the function in the property correctly but it doesn't evaluate it >WITH this.pgfprofile.pagpolicy.policygrid > FOR nColumnID = 1 TO .columncount > colorvalue = "thisform.getpolicycolor('" + .recordsource + "','" + .columns(nColumnID).controlsource + "')" > .Columns(nColumnID).dynamicbackcolor = colorvalue > > *--ColorValue = "this.getpolicycolor('TPOLICY','PO_STATUS')" > *--This is correct, however it is stored as a character expression and doesn't run dyanmically > ENDFOR >ENDWITH >Include whole expression in parentheses. Check your GetPolicyColor method for all rows problem.