• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 9. Improving the Appearance of F... > Applying Conditional Formatting

Applying Conditional Formatting

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint