flag up old data in table

[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

 

[Jeff Boyce]

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

 

[Jeff Boyce]

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>

 

[Jim/Chris]

Display your data in a form and if you have Access 2000 or

you can use Conditional formatting located under the

format menu. Otherwise you will have to use code

Jim