Grey bands on an Access report


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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.

AW 1706-A

 

 

subs profile e1563205311409 - Grey bands on an Access report
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address