highlighing records

[teebumble]

hi,



I have a table with training records.

I would like to have the overdue training records to be highlighted when I open the table. The table has many columns but the important ones are DateAssigned, DateCompleted, and LenDays.

I was thinking of something along this line:

On Current form

if Me!DateCompleted is null then
if Me!LenDays + Date() > Me!DateAssigned then
(highlight the records)
end if
end if

thank you!

[June7]

Cannot do this directly on the table. So are you opening the table, or opening a form with the table as its RecordSource? Check out Conditional Formatting for controls.

[teebumble]

I am opening a form with the table as its RecordSource. I'll look into Conditional Formatting. Thanks. Will reply back after I give that a try.

[teebumble]

I am able to get the "if dateCompleted column is blank, then highlight the record" --- I wrote [DateCompleted] is null in the conditional formatting field.

However, I am still having problem with "if assigned date + lendays has passed today's date, then highlight the record" --- I wrote [dateassigned] + [lendays] > [date] but that didn't work. Any suggestions?

Thank you!

[boblarson]

You would use this with the EXPRESSION IS set instead of VALUE IS:

DateAdd("d", [DateAssigned], [lendays]) < Date()

It would be less than today's date because it would not be overdue until it is behind today.

[teebumble]

Thanks June7 and Boblarson. It works now!