>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:
>------------------------------------------
Just use nested IIF()s
thisform.pgfpagerefresh1.page1.grdnav.setall('DynamicBackColor', ;
'IIF(v_view.totpaid = 0, ;
rgb(255,128,128),;
<b>IIF(v_view.totpaid>0 and !v_view.paidinfull, rgb(0,255,0), rgb(255,255,255))</b>)', ;
'COLUMN')
Insanity: Doing the same thing over and over and expecting different results.