Adam,
Do you have the background set to transparent?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 6 Feb 2015 13:14:08 -0800
Subject: [MS_AccessPros] Re: Conditional formatting not working on continuous form
Duane,
I'm not sure what to tell you. I have criteria expressions like:
In the control [IssueID]
Expression is [StatusSort] =0 (background green)
Expression is [StatusSort] =1 (background blue)
Expression is [StatusSort] =2 (background yellow)
Expression is [StatusSort] =3 (background red)
Or, in the control [LatestUpdate]
Expression is Date() - [LatestUpdate]>7 (background red)
The conditional formatting works when I am in those fields, but only then. When I tab to another field, or to another record, the conditions aren't applied.
I'm wondering if there's something in the form's properties or database settings I need to change, or if there's something about continuous forms. I've done plenty of conditional formatting in continuous forms before and have never had this problem. I'm using 2010.
Adam
Do you have the background set to transparent?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Fri, 6 Feb 2015 13:14:08 -0800
Subject: [MS_AccessPros] Re: Conditional formatting not working on continuous form
Duane,
I'm not sure what to tell you. I have criteria expressions like:
In the control [IssueID]
Expression is [StatusSort] =0 (background green)
Expression is [StatusSort] =1 (background blue)
Expression is [StatusSort] =2 (background yellow)
Expression is [StatusSort] =3 (background red)
Or, in the control [LatestUpdate]
Expression is Date() - [LatestUpdate]>7 (background red)
The conditional formatting works when I am in those fields, but only then. When I tab to another field, or to another record, the conditions aren't applied.
I'm wondering if there's something in the form's properties or database settings I need to change, or if there's something about continuous forms. I've done plenty of conditional formatting in continuous forms before and have never had this problem. I'm using 2010.
Adam
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar