How to Add Alternating Row Colors in Reports in MS Access

You’ve built the report. The data is right. But when you hand it to someone, their eyes glaze over halfway down the page.

That’s not a data problem. That’s a readability problem — and alternating row colors fix it instantly.

This guide walks you through every method to add alternating row colors in MS Access reports: from the one-click automatic approach to manual conditional formatting that gives you full control. Whether you’re presenting financial summaries, sales pipelines, or operational data, you’ll leave with reports people actually read.

Why Alternating Row Colors Matter More Than You Think

Before jumping into the how, here’s the why — backed by data.

Research on data readability consistently shows that alternating row shading (often called “zebra striping”) reduces reading errors by making it significantly easier for the human eye to track across a row. Studies in UX and document design show that structured visual formatting can improve data comprehension speed by up to 20–30%.

In business contexts, this matters:

• Decision-makers scan, they don’t read. A well-formatted report gets acted on. A dense wall of data gets ignored.
• Reports with visual hierarchy are perceived as more credible. First impressions of professionalism directly influence whether someone trusts your numbers.
• Reduced errors in data entry and review. When rows are visually distinct, people are less likely to accidentally read across the wrong line — a critical issue in financial and operational reporting.

Microsoft Access is used by millions of businesses globally for database management and reporting. Despite the rise of newer tools, Access remains one of the most widely deployed database platforms in small and mid-sized organizations, particularly in industries like finance, logistics, healthcare administration, and legal services.

Getting your Access reports right isn’t a nice-to-have. It’s a direct reflection of how you present data to stakeholders.

Method One — Using the Alternate Row Color Feature (Fastest)

MS Access (2010 and later) has a built-in alternating row color tool. This is the fastest path, and it works for most standard reports.

Step-by-step:

Open your report in Design View or Layout View.

Click on the Detail section of the report — this is the band that repeats for each record.

Go to the Format tab in the ribbon at the top of the screen.

In the Background group, you’ll see Alternate Row Color. Click the dropdown arrow next to it.

A color picker appears. Choose your alternating color. The default rows stay at whatever background color you’ve already set (often white). The alternate rows will now display your chosen color.

Switch to Report View or Print Preview to confirm the result.

Pro tips for this method:

• Keep the contrast subtle. A light blue (#D9E8F5) or light grey (#F2F2F2) on a white base reads well without being distracting.
• Avoid high-contrast combinations like dark blue alternating with white — it creates visual fatigue for longer reports.
• This method applies to the entire Detail section. If you need different shading for grouped rows, you’ll need Method Two.

Method Two — Conditional Formatting for Full Control

When you need precise control — different colors for different conditions, groupings, or data values — conditional formatting is the tool.

Step-by-step:

Open your report in Design View.

Click the field (text box) in the Detail section that you want to apply formatting to. If you want the entire row to change color, you’ll need to apply this to each field in the row (or use a rectangle overlay — covered below).

Go to Format > Conditional Formatting in the ribbon.

In the Conditional Formatting Rules Manager dialog, click New Rule.

In the rule type, select Expression Is.

Enter the following expression to create a zebra stripe effect:

=([Report]![Page] Mod 2)=0

Wait — that’s page-based. For row-based alternating, use this approach instead:

Access doesn’t have a native row-number function in conditional formatting, but you can work around it. Create a running count field in your report:

Creating a row counter:

In Design View, add an unbound text box to the Detail section.

Set its Control Source to:

=1

Set the Running Sum property (in the Data tab of the property sheet) to Over All.

Name this text box RowCounter.

Now go back to conditional formatting for your fields. Use the expression:

=[RowCounter] Mod 2 = 0

Set the background color for this rule to your alternating shade.

For rows where RowCounter is odd (the default), leave the background at your base color.

Hide the RowCounter text box by setting its Visible property to No.

Why this method is powerful:

You can layer multiple conditions — for example, highlight rows where a value exceeds a threshold in red, while still maintaining zebra striping for readability. This is the approach used in professional-grade reporting where data tells a story, not just a list.

Method Three — Using a Rectangle for Full-Row Color (Most Visually Consistent)

One limitation of the field-by-field approach is that gaps between fields can look inconsistent. The rectangle overlay method solves this.

Step-by-step:

Open the report in Design View.

Go to Design > Controls > Rectangle and draw a rectangle that covers the entire width of the Detail section.

Set the rectangle’s Back Color to your alternating shade.

Set the Back Style to Normal.

In the property sheet, go to the Format tab and set the Special Effect to Flat.

Now set the rectangle’s On Format event (in the Event tab of the property sheet) to:

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

    If Me.RowCounter Mod 2 = 0 Then

        Me.ShadingRect.Visible = True

    Else

        Me.ShadingRect.Visible = False

    End If

End Sub

(Name your rectangle ShadingRect and your row counter field RowCounter for this code to work.)

This creates a seamless full-row alternating effect — no gaps, no inconsistencies — that looks polished in both screen and print views.

Method Four — VBA for Dynamic Alternating Colors

If you want maximum flexibility or you’re building Access reports programmatically, VBA gives you complete control.

Open the VBA Editor (Alt + F11).

In the Detail section’s On Format event, add:

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

    Static intCount As Integer

    intCount = intCount + 1

    If intCount Mod 2 = 0 Then

        Me.Detail.BackColor = RGB(217, 232, 245)  ‘ Light blue

    Else

        Me.Detail.BackColor = RGB(255, 255, 255)  ‘ White

    End If

End Sub

What this does:

Every time the Detail section formats a new row, it increments the counter and alternates the background color between your two chosen values. RGB(217, 232, 245) is a professional-grade light blue — adjust to match your brand.

Reset the counter for sub-reports or grouped sections:

If your report has groups, reset the counter in the Group Header’s On Format event:

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

    intCount = 0

End Sub

This ensures every group starts with the same base color rather than continuing from the previous group’s count.

Choosing the Right Color Combination

Color choice directly impacts whether your report looks professional or amateurish. Here are combinations that work:

Corporate / Finance:

• Base: White (#FFFFFF)
• Alternate: Light grey (#F2F2F2)

Operational / Dashboard style:

• Base: White (#FFFFFF)
• Alternate: Light blue (#D9E8F5 or #E8F4FD)

High-contrast print reports:

• Base: White (#FFFFFF)
• Alternate: Light yellow (#FFFACD)

Dark-themed executive reports:

• Base: Dark navy (#1F2A40)
• Alternate: Slightly lighter navy (#2A3A55)
• Text: White for both

Rules to follow:

• Contrast ratio matters. The WCAG accessibility standard recommends a minimum contrast ratio of 4.5:1 for normal text. Check your combinations at webaim.org/resources/contrastchecker.
• Stay consistent with your brand. If your organization uses blue in its presentations and dashboards, use a light tint of that blue as your alternating color.
• Test in print preview. Colors that look fine on screen can wash out when printed. Always preview before distributing.
• Avoid red/green combinations. Approximately 8% of men and 0.5% of women have some form of color vision deficiency. Red and green alternating is nearly invisible to them.

Common Mistakes and How to Fix Them

The colors aren’t alternating — they’re all the same shade.

This usually means the Alternate Row Color is set to match the base Back Color. Go to Format properties and confirm both the base color and the alternate color are set to different values.

The alternating breaks mid-group.

If your report uses groupings, the row counter continues across group breaks. Reset the counter in the Group Header’s On Format event (see the VBA section above).

In Print Preview it looks right, but in Report View it doesn’t.

Access sometimes renders differently between views when using VBA-based formatting. Add Me.Repaint at the end of your VBA format event to force a refresh.

The colors appear on blank rows at the end of the report.

Set the Can Shrink and Can Grow properties of your Detail section to Yes. This prevents blank row rendering when the dataset ends before the page fills.

Colors disappeared after I made an edit.

If you reset the Back Style or Back Color property of the Detail section during editing, you may have overwritten the alternate color setting. Re-apply via Format > Alternate Row Color.

Applying Alternating Colors to Sub-Reports

Sub-reports are independent report objects embedded inside a parent report. Each sub-report has its own Detail section and its own formatting rules.

To apply alternating colors to a sub-report:

Open the sub-report in Design View (double-click it in the parent, then right-click > Sub-Report in Design View).

Apply any of the methods above exactly as you would for a standalone report.

The parent report’s alternating color settings do not cascade to sub-reports. Each must be configured independently.

If you’re using VBA counters, each sub-report has its own VBA module — the static counter in the parent does not carry over.

Alternating Colors in Grouped Reports

Grouped reports add a layer of complexity. Here’s how to handle them cleanly.

Scenario: You want alternating colors within each group, resetting at each group boundary.

Use the VBA counter method and reset in the Group Header:

‘ In Group Header On Format event:

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

    intCount = 0

End Sub

‘ In Detail On Format event:

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

    intCount = intCount + 1

    If intCount Mod 2 = 0 Then

        Me.Detail.BackColor = RGB(217, 232, 245)

    Else

        Me.Detail.BackColor = RGB(255, 255, 255)

    End If

End Sub

Scenario: You want group header rows to have a distinct color, different from the detail rows.

Apply a fixed Back Color directly to the Group Header section (not alternating). Use a medium shade of your brand color — this visually separates groups while the zebra striping handles individual row distinction within each group.

Scenario: You want alternating colors to continue across group boundaries (no reset).

Simply don’t reset the counter in the Group Header event. The count continues from the last row of the previous group, maintaining visual continuity.

Exporting Alternating Row Color Reports

One of the most common questions: “Will the alternating colors survive when I export to Excel or PDF?”

Exporting to PDF: ✅ Colors are fully preserved. PDF export renders the report exactly as it appears in Print Preview. This is the recommended export format for distributing reports with custom formatting.

Exporting to Excel: ⚠️ Partial preservation. Access exports the data values but does not reliably transfer conditional formatting or VBA-driven background colors. The built-in Alternate Row Color (Method One) sometimes transfers, but results are inconsistent.

If you need Excel output with alternating colors, export the data and apply Excel’s built-in table formatting instead — it provides the same visual result with better reliability.

Exporting to Word: ⚠️ Limited. Background colors in Access reports do not transfer cleanly to Word. Export to PDF and insert the PDF into Word if needed.

Snapshot format (.snp): ✅ Fully preserved — but this format requires the Access Snapshot Viewer and is rarely used in modern workflows.

Quick Reference: Alternating Row Color Methods

Conclusion

Alternating row colors are one of the highest-leverage formatting improvements you can make to an MS Access report. They’re fast to implement, immediately visible to every person who reads the report, and directly tied to how seriously your data gets taken.

Start with Method One for most reports. Graduate to VBA for grouped or complex reports that need precise control. And always test in Print Preview before distributing — what looks clean on screen needs to hold up in the hands of whoever makes decisions from your data.

The goal isn’t just a prettier report. It’s a report that gets read, understood, and acted on.