*--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 ENDWITH2nd 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