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.
|
