Conditional Formatting on GroupHeader

[eebabe]

I am trying to background color the whole GroupHeader Section but this code doesn't work. What's wrong?

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)

If [Mos_Enrolled] > 0 Then GroupHeader0.BackColor = 12632256
End Sub

This is an Event Procedure that I put in OnFormat in the section properties.

Please advise. Thanks.

 

[dhookom]

What do you mean by "doesn't work"? We can't see your data or your code or your error messages or your results? If you don't share the results, you are limiting our ability to provide help.

At the very least, the stuff after "Then" should be on a new line. Also, there should be some "Else" code to set the back color to whatever it was.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

At the very least, the stuff after "Then" should be on a new line.

Actually, without an ELSE this code works fine.

However, without an ELSE, you have no way of changing the color if the value changes and is no longer > 0.

How about in the OnCurrent event?


Randy

 

[dhookom]

Thanks Randy, I had read the "End Sub" as "End If".

Duane
Hook'D on Access
MS Access MVP