S
Sprinks
I'm trying to use conditional formatting to display a field associated with a
project in Red if there is one or more notes attached to the project in a
table ProjectNotes.
Conditional formatting is set to Expression, equal to:
DCount("[ProjectNoteID]","ProjectNotes","[NoteDate]=#" & [txtMyDate] & "#") >0
If I change the criteria to "[NoteDate]=#1/14/2007#", which is the value of
txtMyDate, the red text conditional formatting is not applied, however the
background becomes grey in all records in the field (it is not disabled,
however). If I cursor into the field and leave, the background in that
record only turns back to white, and if I repaint the form, all records
backgrounds return to white.
Does anyone know what's occurring and how to fix it?
Thank you.
Sprinks
project in Red if there is one or more notes attached to the project in a
table ProjectNotes.
Conditional formatting is set to Expression, equal to:
DCount("[ProjectNoteID]","ProjectNotes","[NoteDate]=#" & [txtMyDate] & "#") >0
If I change the criteria to "[NoteDate]=#1/14/2007#", which is the value of
txtMyDate, the red text conditional formatting is not applied, however the
background becomes grey in all records in the field (it is not disabled,
however). If I cursor into the field and leave, the background in that
record only turns back to white, and if I repaint the form, all records
backgrounds return to white.
Does anyone know what's occurring and how to fix it?
Thank you.
Sprinks