Link to home
Get AccessLog in
Avatar of filtrationproducts
filtrationproductsFlag for United States of America

asked on

Access Continuous form - conditional formatting based on two fields

I have a continuous form I am trying to setup conditional formatting on. I have two fields - assigndue and assigndone. Both are date fields. I want assigndue to have red text when the assigndue date is past due and when assigndone is not filled in (null or blank). I have tried a number of different expressions but I just can't seem to get it to work. Here are a couple i have tried.

([ASSIGNDUE]<"date") And (IsNull[ASSIGNDONE])
([ASSIGNDUE]<"date") And ([ASSIGNDONE]="")
([ASSIGNDUE]<"date") And ([ASSIGNDONE]=NULL)

Thanks in advance!
Capture.JPG
SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
ASKER CERTIFIED SOLUTION
Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Avatar of filtrationproducts

ASKER

That worked. Thanks!!

Dan