I am using Access 2002. I have a simple database of tasks with due dates. I have a report which shows the tasks which are sorted by Due Date. I wanted to use Conditional Formatting to highlight red the tasks which have a due date past today and yellow the tasks due in the next two weeks. It appears the Conditional Formatting feature in Access only works with specific words or numbers and does not work with code like =TODAY(). It works fine in Excel 2002, but I get an error message saying "The expression you entered contains an invalid syntax." in Access 2002. Can you help or offer any suggestions?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2002 Conditional Formatting
- Thread starter jereece
- Start date
Similar threads
- Locked
- Question
- Question
- Locked
- Question