Conditional Format on Yes/No Field

[apodsim]

I am having problem on formatting text on a report based on a Yes/No field using Conditional Rules Manager in Access 2010. When adding a rule [field name] = Yes the font color does not change. I have tried setting the expression to [field name] = True and still does not change the color. Adding a Yes or True in query works OK.

Any help would be highly appreciated.

 

[vbaInet]

Make sure the Back Style property of the textbox is not Transparent.

 

[apodsim]

Before posting my question, I verified that all formatting background, foreground etc. has been set to properly display the values in the field. My suspicion this a another Micro-Soft issue where they release a function this was not properly tested.

 

[vbaInet]

We can't go blaming them yet
What exactly is your condition? And what is the datatype of this field?

 

[GinaWhipp]

Welcome to the Forum!

In addition to vbaInet's post... In the Record Source's SQL, have you change the Bit field to text by doing an IIf Then Statement on the Bit field?

 

[apodsim]

The Data Type is Yes/No in a linked table in Sharepoint Foundation

 

[apodsim]

I not sure what a "bit field" is or where it is located. As noted in my reply to vbaInet's post, the source data is linked to a Sharepoint Foundation Table.

 

[GinaWhipp]

SO, it's a Sharepoint List...hmm, not sure if that is the issue but I can check. It's going to take a little bit I'm going to put a shout out to friends as I have no databases attached to a Sharepoint List to test the theory.

(Might get lucky and maybe vbaInet knows for sure.)

 

[vbaInet]

I've only used Sharepoint to share files/folders and that's it

However, since it's a linked list I would imagine its underlying data type is Boolean (or Bit like datatype) like Gina suggested (not Yes/No), and a Bit datatype has these three values 1, 0 and Null. So instead of using Yes (-1 in Access) you can try using the Integer value 1 for Yes and 0 for No. Exactly as below.

[B][I]Field Value Is[/I][/B] 1

In any case, I still would like to know the exact condition you used in the Conditional Format. In your OP you wrote [Field Value] = 1, this would be incorrect if you selected "Field Value Is" as the condition type.

 

[GinaWhipp]

I have just confirmed that is does in fact work so, as vbaInet has already requested, please post your statement as that does sound like where the problem lies.

 

[fat controller]

Not being funny, but could it be that you are missing quotation marks? I only ask, as I did the very same thing myself only the other day. Try ="Yes" instead?

 

[vbaInet]

Not being funny, but could it be that you are missing quotation marks? I only ask, as I did the very same thing myself only the other day. Try ="Yes" instead?

That would be the wrong thing to do. "Yes" is text and Yes is a boolean-like constant. So for Yes/No fields you use Yes, not "Yes".

 

[fat controller]

Ah - mine was a text box; my bad.