VB Forum / Controls / March 2006

why dont you post in the componentone forum.

AGP

I have a recorset that is displayed in a vsflexgrid.

persno, name, date, hours1, hours2

I want to aggregate hours1 and hour2 for each person.

my code:

 Me.VSFlexGrid1.Subtotal flexSTSum, 1, 3, , vbYellow, vbBlue, True
   Me.VSFlexGrid1.Subtotal flexSTSum, 1, 4, , vbYellow, vbBlue, True

   'Outlinebar zum expandieren
   Me.VSFlexGrid1.OutlineBar = flexOutlineBarSimple

   'Standardmässig collapsed
   Me.VSFlexGrid1.Outline 1

I want to compare the values sum(hours1) and sum(hours2) for each
person.

If they are different, I want to change the backcolor of the
"aggreation row" to red.

Is this possible ?

Thanks
aaapaul