Conditional formatting date validation (1 Viewer)

Hi,

I wonder if someone can help. I need to get access 2003 to use an expression conditional format to flag up red if a textbox contains an off-date such as a weekend. Please see the images below for some background:

i.imgur.com/gpXRWCT.jpg

i.imgur.com/VVgExW1.jpg

With some help from the people that made the actual system they've come up with:

DLookUp("[OffDates]","[tblOffDates]","[OffDates]=#" & [ActionForDate] & "#")

Unfortunately this doesn't work. I just need any date matching the list on tblOffDates to flag up red.

Any ideas?

Thanks in advance!

Try DCount() instead of DLookup() and add >0 to the end.

Thanks for the reply. It's still not working I'm afraid.

I've also noticed it's causing little display anomalies where the text-box is not displaying a background colour whenever the expression type of formatting is activated. Any other ideas? :banghead:

Thanks.