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?
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?
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.
5 people are following this question.