How to Change Access Report Control Properties for Each Record
Question details
The user needs to display different properties, such as background colors, for the same control based on the specific values of each record in an Access report.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Designing a database report where controls require distinct, dynamic formatting per record to highlight specific data.
- Observed behavior
- Standard label controls do not support conditional formatting natively, making it difficult to apply record-specific properties without alternative methods or VBA.
Ensure your database report is open in Design View and identify the specific field or control that requires dynamic formatting before making structural changes.
Convert the Label to a Text Box for Conditional Formatting
This is the simplest method for applying dynamic colors or styles without writing VBA code, bypassing the limitation of standard labels.
Since Microsoft Access does not support conditional formatting for label controls, you can trick the system by converting the label into a text box. This allows you to leverage the built-in conditional formatting tool while maintaining the appearance of a standard label.
Right-click the target label in your report's Design View, hover over 'Change To', and select 'Text Box' from the context menu.
Open the Property Sheet for the new text box, go to the 'Data' tab, and set the 'Control Source' property to your desired static string, such as ="First Name".
With the new text box selected, navigate to the 'Format' tab on the ribbon and click 'Conditional Formatting'.
Click 'New Rule', specify the condition based on the record's values (e.g., Field Value is equal to "Smith"), select your desired background or font color, and click 'OK'.

Configure Properties via the Detail Section's On Format Event
For complex property changes beyond basic formatting, use VBA code triggered by the report's Detail section events.
Looking for a Free Office Suite? Try WPS Office
While Microsoft Access handles complex database queries and reporting, for your everyday document processing, spreadsheet analysis, and presentations, WPS Office offers a powerful, lightweight, and completely free alternative. It features high compatibility with standard office formats, ensuring a seamless transition.

Frequently Asked Questions
Why can't I apply conditional formatting to standard labels in Access?
Microsoft Access natively restricts conditional formatting to bound or calculated controls, such as text boxes and combo boxes. Labels are static display controls and lack the underlying data connection required to evaluate dynamic property changes via the Conditional Formatting menu.
Can I format an entire row's background color dynamically without using VBA?
Yes. You can add an unbound text box that spans the entire width and height of the Detail section. Send this text box to the back (behind all other controls) and apply Conditional Formatting to it. It will act as a dynamic background for the entire row based on the rules you set.
Will my On Format VBA code work if I open the report in Report View?
No. The On Format and On Print events are specifically designed for pagination and rendering to a printer. They only trigger when the report is printed or viewed in Print Preview. If you use Report View, you must rely on standard Conditional Formatting instead.




