Yes/No Field making me crazy

[Mythblstr]

I posted this in the wrong thread yesterday

I just started learning Access and I have created a database with 53 records, 3 tables and 1 Split form. I creared a new yes/no field and I am attempting to display "Completed" in green for yes and "Not Completed" in red for no. I used the correct code in the format field:

"Not Completed "[Red];" Completed "[Green]

This worked for different field before I created the split form but now I cannot get the new field to display anything but check boxes regardless of what code I use. It won't even let me use the default yes/no, true/false or on/off options.

I've been studying this for about 2 weeks and I've figured out quite a bit but this one thing is really iritating me....

Help
Any comments would be appreciated
John

 

[Exodus]

Sounds like you are using a check box as the control type.

Use a combo box and set its row source type to Value list
For Row Source type in
0;Not Completed;-1;Completed

leave bound Column to 1

Set the Column Count to 2
Set column widths to 0;1


This shoukd give you a combo box that displays Not completed and Completed

You will need to set the control source to the field your yes/no field.

From here you can use conditional formating to change the color of the font.

 

[Mythblstr]

Thank you Exodus, I got it to change in the datasheet but now it won't update in the split form view even though I did save it. What do I need to do to have the change reflected in the split form?

 

[Exodus]

Sorry Mythblstr I just realized you are running Access 2007. I am not familar with this version of Access and split forms. I would assume that you should be able to do the same thing on both controls of the form.