Others

How to Apply Permanent Record Colors in a Continuous Access Form

WPS Content Manager Sep 27, 2026 869 views

Question details

The user needs to display a different background color for each record in a continuous Microsoft Access form based on a specific stored field.

How to Apply Permanent Record Colors in a Continuous Access Form

Product: Microsoft Access
Device & OS: not provided
Scenario: Customizing the appearance of multiple visible records simultaneously in a continuous form view.
Observed behavior: Attempting to set colors using the On Current event fails because it uniformly formats all displayed rows based on the currently active record.

Before you start

Ensure your Access form's underlying table or query includes a field (such as COLORTEXT) that stores the specific value or status you want to base the color changes on.

Solution 1Recommended

Use Conditional Formatting for Record Colors

Apply conditional formatting to the form controls to independently evaluate and set background colors for every row.

In a continuous form, the On Current VBA event is not suitable for formatting because it affects the active record and forces all other visible rows to inherit the same style. Conditional formatting natively processes expressions row by row.

Open form in Design View

Right-click your continuous form in the navigation pane and select Design View.

Select the target controls

Click to select the text box or combo box controls you want to colorize. To color the whole row, hold Shift and select all controls in the Detail section.

Open the Conditional Formatting Rules Manager

Navigate to the Format tab on the ribbon and click on the Conditional Formatting button.

Create a new expression rule

Click New Rule. Under 'Select a rule type', choose 'Check values in the current record or use an expression'. Select 'Expression Is' from the drop-down menu.

Enter the condition and apply colors

Type your condition, for example: [COLORTEXT]="Red". Next, click the Fill Color bucket icon to choose a background color, then click OK to save and apply.

Use Conditional Formatting for Record Colors

Pro Tip: You can add multiple conditional formatting rules to the same controls to accommodate various color values stored in your database.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While WPS Office does not include a direct database alternative to Microsoft Access, it provides a powerful, free, and lightweight suite for all your document, spreadsheet, and presentation needs, ensuring highly compatible formats and seamless migration from Microsoft Office.

1. Download WPS Office: Visit the official WPS website and click the free download button for your operating system.
2. Install the Suite: Run the installer and follow the quick on-screen instructions to set up the software.
3. Open and Edit Files: Launch WPS Office and instantly open your existing Word, Excel, or PowerPoint files without formatting loss.

Free to download and use with a lightweight installationFully compatible with Microsoft Word, Excel, and PowerPoint formats (docx, xlsx, pptx)Familiar user interface makes switching easy and requires no learning curveAll-in-one tabbed interface for seamless document management

microsoft office alternative - wps office

Frequently Asked Questions

Why does the On Current event change the color of all rows?

The On Current event runs only for the active record. When you change a control's property via VBA in a continuous form, the change affects the single control template, which Microsoft Access then uses to draw all visible rows. This results in all rows uniformly displaying the formatting of the currently active record.

Can I format the entire row background instead of just the text boxes?

Access conditional formatting applies exclusively to controls, not the row background itself. To simulate a colored row, you must select all text boxes spanning that row, remove any gaps between them, and apply the exact same conditional formatting rule to all of them.

Is there a limit to how many conditional formatting rules I can apply in Access?

In Access 2010 and newer versions, you can apply up to 50 conditional formatting rules per control. In older versions like Access 2003, the limit was strictly 3 conditions plus the default format.

Office Quick Solutions