We have an Access database that lists the jobs that are pending. It shows the title, due date, if completed Y/N, what group is working on the project, etc. What we would like is for the "Due Date" to turn from black to "BOLD", "RED" and "BLINK" whenever the listing is shown on the screen or printed. When the field that indicates that the job has been completed with a "Y" or a "completion Date is entered, then the DUE DATE will return to its normal appearance.
Any suggestions that you can give will be appreciated.