>"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 >Endif >>As 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