conditional formatting of a checkbox

[survivo01]

I found this formula in the search. but I am not sure whether I am using correctly. (Wish I had kept the Name of who showed it)



I have a checkbox yes/no called GED I am assuming if it is blank the answer is no and I am using this formula if [ABE] = No then [ABE].forecolor = vbred else [ABE].forcolor = vbblack Also, what event should it be listed as.

[June7]

Is this on a form or report that displays multiple continuous records? Don't use event coding. Use Conditional Formatting.

Use Nz function to return a value if field is null.

Nz([ABE],No) = No

[survivo01]

Do you mean the conditional formatting that is built in. I tried to change the check boxes to text boxes and for some reason the conditional formatting tool did not work. I guess I am not making myself clear. I just want to make my check box red if it is no

[June7]

Well, darn! Checkboxes don't have BackColor or Font properties and therefore don't have conditional formatting although would be nice to use CF to enable/disable checkbox. However, a textbox bound to a Yes/No field should have both available - does for me.

VBA method will work if only one record at a time displays. Put code in the form Current event and maybe even in the textbox AfterUpdate event.

[survivo01]

Okay, I changed the check box to text box. I used the conditional formatting tool. The tool appeared to work fine but nothing changed on the form. I have used it before without problem. I don't know if it should make a difference this is the main form that contains a sub form

[June7]

Select ExpressionIs in the CF wizard.

Then try:

Nz([ABE],No) = No

or

Nz([ABE],False) = False

or

Nz([ABE],0) = 0

Work for me.

[survivo01]

I did what you suggested and I get nothing. I am using ACCESS 2007. Could I have something wrong with my program

[June7]

I would have to examine the database. If you want to provide follow instructions at bottom of my post. However, I will not be able to work with db files for 2 weeks starting tomorrow.