Conditional formatting based on table values MS access

Question

Hi,

I have a general table and another one with specified dates, how to highlight dates which included in the second table using conditional formatting inside form or report?

Answer 1

In the conditional formatting expression call the DLookup function like this:

DLookup("ColumnName","TableName","ColumnName = #" & Format([ControlName],"yyyy-mm-dd") & "#") IS NOT NULL

Note that the use of the ISO standard for date notation of YYYY-MM-DD when building the date literal prevents any international ambiguity of the date format.