Join Alicia Katz Pollock for an in-depth discussion in this video Using conditional formatting, part of Access 2010 New Features.
Access 2010's conditional formatting has a new interface with the addition of data bars.…Let's open up our Salaries Report.…Conditional formatting can be used on all forms and reports so that you can…color-code significant values.…The new data bars give you a visual comparison as well.…We are going to apply them to our Salary column.…So, while you have a Formula Report open go to the Layout View and then in the…Report Layout Tools go to the Format tab.…Click in the field that you want and you'll notice that they'll all highlight.…
Then I'll click on the Conditional Formatting button.…Notably, the new dialog box lets you switch between your fields so you can apply…conditional formatting all in one place instead of one field at a time.…Let's create a rule.…I'll click on New Rule.…We are going to set the Salary so that if the field value is greater than or…equal to 3000 we'll have it turn bold and green. And then I'll click OK.…I'll add a second rule and this time I make it so that the field value is less…
- Working with Application Parts
- Implementing the Table Tools ribbon
- Using Quick Start and calculated fields
- Designing with Layout View formatting tools
- Taking advantage of enhancements to the Conditional Formatting feature
- Automating with macros
- Working with external data
- Integrating SharePoint publishing
Skill Level Intermediate
Q: My macro isn't running correctly. I followed along with the author and I'm not receiving an error message, but the actions are performed correctly.
A: There are several possible reasons why a macro would malfunction. Make sure that the macro is written correctly. Capitalization and punctuation matters. Also make sure to click in all the same places when recording the macro. With enough practice, building macros will become more routine, and spotting errors will becoming easier.