Variable Group Header Headings?

[sdkramer]

I have a report with a group header that distinguishes type1 from type2. I also have the heading for the columns in the group header. Depending on if it's type1 or type2 I would like one of the headings to change.

Example:

Type1
Name Address Phone
Steve 12 Maple 911
Mark 3 Oak 411

Type 2
Name Address Email
John 23 North john@stupidemailaddress.com
Mary 17 Mutton supermary@goofymail.com

Doable? Any ideas?

 

[Rich]

=Iif([myField]="Type1","Phone","EMail") as the control source for an unbound textbox