S
spgonz
In Access 2000 I have a form being displayed as a
continuous form. In the form I have fields of "Date Due"
and "Date Completed. I want to have the form
background/fill color change to red if "Date Completed"
is null and if "Date Due" is less than current date and
change to yellow if "Date Completed" is null and "Date
Due is less than current date +7. Anyone have an idea
how to do this.
Thanks
continuous form. In the form I have fields of "Date Due"
and "Date Completed. I want to have the form
background/fill color change to red if "Date Completed"
is null and if "Date Due" is less than current date and
change to yellow if "Date Completed" is null and "Date
Due is less than current date +7. Anyone have an idea
how to do this.
Thanks