date calculation

[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

 

[Duane Hookom]

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.

 

[John Vinson]

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

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.

 

[Claude]

-----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

any problems I will come back thanks again to all that
responded
Claude