Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Howto color individual cells in a grid
Message
From
03/03/2005 03:00:52
 
 
To
03/03/2005 01:15:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00992278
Message ID:
00992294
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
Hi Gunnar.

The problem you are having is that the DynamicBackColor is evanuated in the context of the Grid, not the Column. There for "This" refers to the Grid, not the column you are looking at. If you reference the Field Name in the expression instead of This.ControlSource it should work fine. If you are trying to get each column to display a color based not on the record, bot on only the field in the column then something like this should work -

Local loColumn
For each loColumn in This.Columns
If Type(loColumn.ControlSource) $ "NFIBY"
loColumn.DynamicBackColor = "iif("+ loColumn.ControlSource +" < 0, Rgb(255,0,0), Rgb(255,255,255))"
EndIf
EndFor
loColumn = .NULL.

Ian Simcock.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform