Others

Highlight an Entire Access Form Row Based on a Drop-Down Value

Rana GarciaRana Garcia Nov 20, 2026 868 views

Question details

The user wants to highlight an entire Access form row when a drop-down has a specific value.

Highlight an Entire Access Form Row Based on a Drop-Down Value
Product
Microsoft Access
Device & OS
not provided
Scenario
A continuous form displays records with a status combo box, and rows marked Incomplete should have a different background color.
Observed behavior
The desired result is a row-wide highlight that changes according to each record's selected status.
Before you start

Open the form in Design View and check that its Default View is Continuous Forms. On the combo box's Property Sheet, check its Control Source and Bound Column so you can compare the stored status value rather than a display label.

Solution 1Recommended

Use a Conditionally Formatted Text Box as the Row Background

Use this approach to highlight the detail row when each record's bound status value matches the condition.

Access conditional formatting applies to text boxes and combo boxes, not rectangle controls. A text box placed behind the other controls can act as the row background.

For different rows to show different highlights, the combo box must be bound to a field in the form's record source. Replace Status and Incomplete in the example with the actual field name and stored value.

1
Add a background text box

In Design View, use Design > Text Box to add a text box to the Detail section. Remove its attached label and resize the text box to cover the row.

2
Set its properties

Select the text box and open Property Sheet. Set Control Source to ="", Back Style to Normal, and Border Style to Transparent. Set its normal background color to the form's default row color.

3
Move it behind the controls

Right-click the text box and choose Send to Back. Set foreground controls' Back Style to Transparent where available so the highlight can show through.

4
Add the condition

With the background text box selected, choose Format > Conditional Formatting > New Rule. Select Expression Is and enter [Status] = "Incomplete". Choose the highlight background color and select OK.

5
Test the form

Save the form and switch to Form View. Select Incomplete in a record's combo box and check that its row is highlighted; select another status to check that the normal color returns.

Use a Conditionally Formatted Text Box as the Row Background
Check the stored value: If the combo box displays Incomplete but stores a numeric ID, compare the status field with that ID instead. Controls with opaque backgrounds may need their own conditional formatting to match the row.
Free Microsoft Office alternative

Track Statuses in WPS Spreadsheets

WPS Office is a free, lightweight alternative for spreadsheet-based status tracking. Its familiar interface and Microsoft Office format compatibility make it easy to move spreadsheet data into WPS. It does not edit Access forms or directly replace this Access solution.

Use spreadsheet conditional formatting to highlight status entriesOpen and save Microsoft Excel formats, including XLSXWork with a familiar, easy-to-use spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

What expression highlights rows marked Incomplete?

In the background text box's Conditional Formatting rule, choose Expression Is and enter [Status] = "Incomplete". Use the actual field name and stored value from your form.

Why doesn't the rule work when the combo box displays Incomplete?

The combo box may display a label but store a numeric ID. Check its Bound Column and Control Source in Property Sheet, then compare the field with the stored ID rather than the displayed text.

Can I apply the conditional formatting rule to a rectangle?

No. Access conditional formatting is available for text boxes and combo boxes. Use a text box behind the row controls as the conditional background instead.

Why do some controls cover the row highlight?

Controls with opaque backgrounds can hide the background text box. In Design View, set their Back Style to Transparent where available, or apply matching conditional formatting to the controls themselves.