date calculation

  • Thread starter Thread starter Claude
  • Start date Start date
C

Claude

I need my Db to look at a expiration date that is entered
in a field in a record and turn this date red when it
reaches 90 days prior to the entered date. can this be
done and how do i do it...I am lost

thanks
Claude
 
You can use a form with Conditional Formatting (assuming Access 2000 or
greater). Check it out and if you have any questions, come on back.
 
I need my Db to look at a expiration date that is entered
in a field in a record and turn this date red when it
reaches 90 days prior to the entered date. can this be
done and how do i do it...I am lost
Click to expand...

It cannot be done in a Table. Table datasheets are very limited in
their capabilities.

It's pretty easy to do on a Form, with a little VBA code.
 
-----Original Message-----
You can use a form with Conditional Formatting (assuming Access 2000 or
greater). Check it out and if you have any questions, come on back.

--
Duane Hookom
MS Access MVP





.
Thanks for the idea, I am very new to Access, if I have
Click to expand...
any problems I will come back thanks again to all that
responded
Claude
 
Back
Top