Hi John, I suggest you change your DynamicForeColor and DynamicBackColor expressions as follows in order to eliminate the possibility that your public variable lnRow is going awry and to eliminate any issue with the IIF() statement.
WITH ThisForm.Grid1
.SETALL("DynamicBackColor", "IIF( .F., RGB(0,0,128), RGB(255,255,255))", "Column")
.SETALL("DynamicForeColor", "IIF( .F., RGB(255,255,255), RGB(0,0,0))", "Column")
ENDWITH
This will create plain black on white grid. Obviously this removes your desired colour effects for the moment but it will narrow down the field of investigation. If this works ok then you can put back your RECNO() test and the lnRow variable. In this way you can find out what part of the DynamicColor expression is failing.
>Hi,
>I have change rem all my DYNAMICCOLOR code and replace it with GRIDHIGHLIGHTER class that download from download section.
>After a period of testing, the error of "invalid expression" still occured. The problem is as same as before, error will not occured everytime, but may be ONCE after a period of time.
>
>Any ideas?
>
>Thank you
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.