I have a number of fields in my table which are simple lookups with two items in the lookup : "yes" and "no". I've done this rather than use a checkbox, because it's very important that I can do conditional formatting on the columns when these are viewed in a datasheet, which isn't possible using checkboxes.
In all of the columns I have implemented the formatting using a very simple expression as follows
or
which colours the background of the cell red or green accordingly. This is working well for all of my fields, except for this one which fails. Both expressions fail so no rules are used to format the cell. Yet in that same field, if I set the conditional formatting to directly check the value against either "yes" or "no" it works fine. It only doesn't work if I use an expression which references the field. But I need to use an expression as I need to add another condition to the expression (which is already working fine in all the other fields).
I've recreated the rules a dozen times, using the expression builder, there are no typos here. I've checked the lookup list over and over. The broken field is literally identical to the others that all work fine. It also fails the same way if I put the same formatting rules into a different field, and reference this broken field in those rules. So it looks like it's failing to read the field, or the values are being read differently somehow.
Is there any kind of "debug" mode where I can see what Access thinks the value of the field is when it's running the expressions?
In all of the columns I have implemented the formatting using a very simple expression as follows
Code:
[Field1] = "Yes"
Code:
[Field1] = "No"
which colours the background of the cell red or green accordingly. This is working well for all of my fields, except for this one which fails. Both expressions fail so no rules are used to format the cell. Yet in that same field, if I set the conditional formatting to directly check the value against either "yes" or "no" it works fine. It only doesn't work if I use an expression which references the field. But I need to use an expression as I need to add another condition to the expression (which is already working fine in all the other fields).
I've recreated the rules a dozen times, using the expression builder, there are no typos here. I've checked the lookup list over and over. The broken field is literally identical to the others that all work fine. It also fails the same way if I put the same formatting rules into a different field, and reference this broken field in those rules. So it looks like it's failing to read the field, or the values are being read differently somehow.
Is there any kind of "debug" mode where I can see what Access thinks the value of the field is when it's running the expressions?