Highlight an Entire Access Form Row Based on a Drop-Down Value
Question details
The user wants to highlight an entire Access form row when a drop-down has a specific 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.
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.
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.
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.
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.
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.
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.
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.

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.

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.




