Skip to content

Changing Color of the Highlighted Record on a Tabular Form

How to use conditional formatting to change the color of the highlighted record in a tabular form.

Q:Ashjan Al Mahmeed wants to know how to change the color of the highlighted record in a tabular form.

A:This can be done with conditional formatting (a feature added to Access in Office 2000).  For each control on the form that you want to change color (generally, text boxes and combo boxes), select the control in Design view, select Format|Conditional Formatting (or select Conditional Formatting from the control’s right-click menu), select Field Has Focus for Condition 1, and select the highlighting color of your choice.  This has to be done separately for each control – on a tabular (datasheet) form or subform, this would generally be text boxes and combo boxes.  Once you have set the appropriate conditional formatting for all the necessary controls, the highlight will display when the form is opened, either independently, or as a subform on another form.

About this author