flag up old data in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

in my table i enter the date on each reccord and i want
the table to automatically flag the data that is 4 days
old by making it red or something, anything will do please
help
 
in my table i enter the date on each reccord and i want
the table to automatically flag the data that is 4 days
old by making it red or something, anything will do please
help
Click to expand...
 
If you are working directly in the table, rather than via a form, I'm not
sure there's a way to do what you're asking.

If you create a form, based on the table, you can add a bit of code to the
forms OnCurrent event, that tests for the "days old" (by subtracting from
today's date), and turns the date field's background color (or label, or
text, or ...) to red.

Good luck

Jeff Boyce
<Access MVP>
 
Display your data in a form and if you have Access 2000 or
you can use Conditional formatting located under the
Click to expand...
format menu. Otherwise you will have to use code

Jim
 
Back
Top