Conditional formatting on group header

[jmk0576]

Is it possible to conditionally format a group header. I would like the background color and title to change when group changes. I understand how to set it within the detail section on a specific field but need to change the title of the group header when group changes. Any suggestions would be appreciated. Thanks!

[June7]

Don't understand what you mean by 'change the title of the group header'. Should that have been 'change the color'?

Do you just want the background color to alternate between two colors so each group is distinguished from neighbor group? Try setting the Alternate Back Color property to 'Alternate Row'.

[pbaldy]

I'm not sure I understand. By definition, wouldn't the title change when the group changes? Can't you just change the color of the group section in design view?

[jmk0576]

Yes, I want to change the background color in the group header as well as change the text. The text and background color will be based on the value of the field I used in the group. For example, Group One is Yellow and this grouping is for projects in the vetting stage, Group Two is Blue and is for projects in the budgetting phase .....

I was not able to find an option to dynamically change the group header.

[pbaldy]

Here's a quick and dirty example:

    If Me.FieldName = 1 Then        
        Me.GroupHeader0.BackColor = vbYellow
    Else
        Me.GroupHeader0.BackColor = vbWhite
    End If

I might have the options in a table, but this should get you started.

[jmk0576]

Thanks for the code... where do I place it.

[pbaldy]

Sorry, the format event of the group header section.

[June7]

Be aware OnFormat event only triggered when printed or PrintPreview, not Report View.

[jmk0576]

Thank you very much it works the first time it is displayed in print preview. However, If I scroll thru the pages intially all the colors are correct but when I go back the colors change to the last one that was displayed. Do I need to add this to another Event to eliminate this issue.

[pbaldy]

I don't get that behavior in my test. What exactly is your code? Can you attach the db here?

[jmk0576]

I resaved everything and it is working ... code was only in the Format event for the Section. Thanks, again completed.

[pbaldy]

No problem.