| You can make your reports and forms more powerful by setting up conditional formatting. Conditional formatting allows you to format a field based on values the user enters. For example, you can use a conditional format to make negative values appear in red and positive values appear in black. Apply Conditional Formatting to a Field -
| | Display the form or report in Design view, and then click the field to which you want to apply conditional formatting. | -
| | Click the Format menu, and then click Conditional Formatting. | -
| | Specify the default format for the field. | -
| | Click the Condition 1 list arrow, and then select Field Value Is. | -
| | Click the second list arrow, and then select a condition type. | -
| | Enter values for the condition. | -
| | Specify the format when this condition is true. | -
| | Click Add to add a second formatting condition. | -
| | Click OK to apply the conditional formatting. | Did You Know? You can use expressions in a conditional format . For more complicated conditional formats, select the input field, click the Format menu, and then click Conditional Formatting. Click the Condition 1 list arrow, select Expression Is, type the conditional formatting expression in the box to the right, and then click OK. | |