Microsoft Office Tutorials and References
In Depth Information
Making Reports Look Pretty
give you a
quick way to
of a report.
5. Select a theme to choose it for your report.
Access displays your report with your selected theme.
Creating conditional formatting
A report can display data, but sometimes you may want help in identifying
certain types of data. For example, you might want Access to highlight sales
figures that are greater than $250,000 so you can spot this information easier.
While you could manually examine a report and highlight such information
yourself, it’s faster and more accurate to let Access do it instead.
Formatting data based on certain criteria is known as conditional formatting.
The idea is that Access formats data only when certain conditions are met,
such as a value greater than $250,000 or less than $10,000.
To use conditional formatting, you need to define the field to format, define
a rule to trigger the formatting, and then the type of formatting you want to
apply, such as highlighting the field in red or yellow.
To apply conditional formatting to data in a report, follow these steps:
1. Display your report in Design view.
Follow the steps in the sidebar “Switching to Design view.”
2. Select the field to which you want apply conditional formatting.
You can apply conditional formatting to a numeric or text field.