General information
Category:
Forms & Form designer
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')
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only