S
sara
The problem:
Conditional formatting bold, red when field Value < date() sets the field
background to white - always - whether condition is met or not.
Background:
I have 2 related fields that are only rarely active, so I manage them in the
query for the subform: ShowBlanket: IIf([BlanketPO],"Blanket","") and
ShowBlanketExpDate: IIf([BlanketPO],[BlanketExpDate],"")
This works perfectly, BUT I want to alert the user if, when there is a
blanket in the list, the Expiration Date has passed. That's when I tried
conditional formatting on the field in the continuous view subform. The
fields show perfectly (blank or with data) until I apply the conditional
formatting.
Many thanks.
Sara
Conditional formatting bold, red when field Value < date() sets the field
background to white - always - whether condition is met or not.
Background:
I have 2 related fields that are only rarely active, so I manage them in the
query for the subform: ShowBlanket: IIf([BlanketPO],"Blanket","") and
ShowBlanketExpDate: IIf([BlanketPO],[BlanketExpDate],"")
This works perfectly, BUT I want to alert the user if, when there is a
blanket in the list, the Expiration Date has passed. That's when I tried
conditional formatting on the field in the continuous view subform. The
fields show perfectly (blank or with data) until I apply the conditional
formatting.
Many thanks.
Sara