Q: On one of my Access reports, strange light grey bands print here and there. What causes them, and how do I remove them?
A: This is most likely because of the Access default setting for Alternate Back Color for group headers and footers in reports. Alternate row shading is an excellent feature for the detail section of list-type reports, but it is rarely useful in headers or footers, and it will cause bands of a different back color in every other header or footer. To turn it off, select the header or footer in Design view and select No Color for the Alternate Back Color property.
