"Expression is invalid. Use a valid expression for Dynamic..."
and I get it at least twice for each.Select CENZNFLD If SEEK( lnCompID) Scan While AP_ID = lnAPID ; And AP_FLD_ID = lnAPFldID lcFieldName = ALLTRIM( FIELD_NAME) lnAPFactor = AP_FACTOR Select csrZVARXACT Locate For ALLTRIM( FIELDNAME) = lcFieldName If FOUND() replace FIELDVAL With lnAPFactor In csrZVARXACT Endif Endscan With Thisform.grdCenZoneFields .SetAll( "DynamicBackColor", "IIF( AP_FACTOR > 0, RGB( 0, 0, 255), RGB( 255, 255, 255))", "Column") .SetAll( "DynamicForeColor", "IIF( AP_FACTOR > 0, RGB( 255, 255, 255), RGB( 0, 0, 255))", "Column") Endwith EndifAs far as I can ascertain the syntax is exactly as in Help, i.e.
frmMyForm.grdGrid1.SetAll("DynamicBackColor", "IIF(MOD(RECNO( ), 2)=0, ; RGB(255,255,255), RGB(0,255,0))", "Column")Thanks