Larry:

Thanks for the help. Hate to ask, but do you have an example?

TIA


>You can use nested IIF()s as Trey suggested or you can set the DynamicBackColor to a form-level functio/method. The method could have a CASE statement. When you have several options, some times this is a better way to go because of readability/maintainability.
>
>HTH.
>
>>I would like to highlight rows in a grid based on a status field in the view. Right now i can set the background color for just one 'situation' but not multiple. For example, i would like to show PaidInFull rows in green, payment greater than zero (but not in full) in yellow, and where not paid at all in pink. I can do this for just one situation but not for all three.
>>
>>Can anyone suggest a technique?
>>
>>------------------------------------------
>>i use the following to set the background:
>>------------------------------------------
>>
>>thisform.pgfpagerefresh1.page1.grdnav.setall('DynamicBackColor', ;
>> 'IIF(v_view.totpaid = 0, ;
>> rgb(255,128,128),rgb(255,255,255))', ;
>> 'COLUMN')
>>
>>thisform.pgfpagerefresh1.page1.grdnav.setall('DynamicForeColor', ;
>> 'IIF(DATE()=DATE(), ;
>> rgb(0,0,0),rgb(0,0,0))', ;
>> 'COLUMN')