Control Highlight Record For Free

On the Home tab, click Conditional Formatting. Point to Highlight Cells Rules, and then click Text that Contains. Type the text that you want to highlight, and then click OK.

You can highlight values or records in a Microsoft Access report using conditional formatting. Conditional formatting is used to change the appearance of a bound control such as a text box based on a rule.

Select the Home tab, locate the Text Formatting group, and click the Alternate Row Color drop-down arrow. Select a color from the drop-down menu, or select No Color to remove the alternate row color. The alternate row color will be updated.

To select a block of records, click the record selector column next to the first record in the block, press and hold down the Shift key, and click the last record's selector column. To select a column, click the column heading.

You can highlight values or records in a Microsoft Access report using conditional formatting. Conditional formatting is used to change the appearance of a bound control such as a text box based on a rule. Certain conditions must be met in order for the formatting to be applied.

You can use the Color Builder in Access to determine the correct RGB numbers to use to express any color. In forms Design, click the BackColor, BorderColor, or ForeColor property, and then click the Build (ellipsis) button that appears next to the property name.

The AlternateBackColor property contains a numeric expression that corresponds to the color used to display on alternate rows of the specified section. Use the Color Builder to set this property by choosing the Build button to the right of the property box in the property sheet.