Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DynamicBackColor
Message
From
29/03/2005 14:24:38
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
00999758
Message ID:
00999762
Views:
46
Thanks Nadya,

that got my brain going. I got what I wanted with this:

iif(inlist(mod(recno(),8) 1, 2, 3, 4), GreenColor, RedColor)

>>Hi,
>>
>>I have a grid which is displaying information like this:
>>
>>Age   5yrs   10yrs   20yrs
>>50    1235   1345   7676576
>>50    3234   54365  658678
>>50    87668  87699  768898
>>50    76576  65767  09809
>>55    876987 090980 09809
>>55    765876 989878 768767
>>55    876876 785457 6757687
>>55    654655 435354 6546565
>>60...
>>
>>and so on, in groups of 4 records per each age.
>>
>>I want to highlight alternating groups to make it easier to read. What formula can i use to do this?
>>
>>Thanks.
>
>From the top of my head:
>
>iif(mod(recno(),8) <5, GreenColor, RedColor)
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform