Where is conditional formatting in access 2010

Answer: If you want to highlight a field that "Is Null", you can apply conditional formatting. To do this, open your Access report and highlight the field that you want to change the behavior of. In this example, we've selected the OrderDate field. When the Conditional Formatting window appears, select "Expression Is" from the drop-down. And then enter the following formula:.

Learn more. MS Access conditional formatting values stored in field of table? Ask Question. Asked 8 years ago. Active 8 years ago. Viewed 6k times. Select Case Me. So, a. Should I use the VBA example and test each case? Add a comment. Active Oldest Votes. Gord Thompson Gord Thompson k 27 27 gold badges silver badges bronze badges.

Thanks for answering. Obviously it works for you. After getting to work, I realized my report is based on a query, and none of the fields are named the same nor are in "Camel Case"!

So I quickly created a new table with the same field names I gave in the question, and created a report on this table. Could you add a screen shot to show me where you've typed the expression into. You can work with most any report, as long as there's a date field to work with. I entered just three records to keep things simple. To apply this particular conditional formatting rule to a date field in a report the All Tasks report , do the following:.

In English, this rule says the following: If the due date falls within the next seven days, display that date in red. In this example, we applied only one simple rule, but the feature is much more robust. Access' conditional formatting feature is just as comprehensive, flexible, and powerful as Excel's. Use it to alert users conditionally, in both forms and reports. Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

To apply this particular conditional formatting rule to a date field in a report the All Tasks report , do the following: Open the report in Design view. Select the date field. In this case, that's the Due Date field.

Click the contextual Format tab.