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