How do we make a due date stand out if it is less than 30-days away on an ACCESS database?
Posted on 2014-09-04
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.