>>
>>Don, could you post the exact command that is NOT working? You'll get quicker results that way.
>>
>>Also, check the code in the Help system for DynamicBackColor. The example may help you find the error.
>>
>>HTH
>>Barbara
>
>Thanks Barbara,
>
>The command I use in the interactive change event of a textbox is as follows:
>
>thisform.gridsched.SetAll("DynamicBackColor", "IIF(between(entereddate,templates.date_from,templates.date_to),;
> RGB(64,0,128), RGB(191,255,255))", "Column")
>
>The entereddate,templates.date_from,templates.date_to are all date type variables and this command initially works but if you erase the entered date in the textbox as in to reenter a new date the error invalid expression pops up.
>
>Thanks,
>
>Don

Hi, the only thing I see is when you erase the entereddate value, maybe the variable
erases completly or the type of the variable has changed when the grid refresh. Maybe you should use a property
like THISFORM.enteredDate. So the variable will be always present.

Hope this help.