Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Several colors in a grid according to conditions
Message
From
04/06/2007 09:51:16
 
 
To
04/06/2007 09:48:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01230208
Message ID:
01230210
Views:
21
This message has been marked as the solution to the initial question of the thread.
>Hello,
>
>Is there a simple way to have several colors for rows (backcolor) in a grid according to conditions ?
>
>For example, the result I want :
>record 1 : red
>record 2 : blue
>record 5 : blue
>record 10 : green
>
>Result of condition 1 : record 2+5 colored in blue
>Result of condition 2 : record 1 is colored in red
>...
>
>I've tried things the AfterRowColChange method :
>
>thisform.grid.SetAll("dynamicbackcolor","IIF(My condition,RGB(128,128,255),RGB(0,128,255))","Column")
>
>
>But it works if you want only 2 colors. I have 4 ou 5 differents conditions, so 4 ou 5 different colors...
>
Use it this way:
thisform.grid.SetAll("dynamicbackcolor","thisform.setgridcolors()","Column")
and your custom form method 'setgridcolors' may return any set of values based on some recordsource field.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform