When viewing a form in datasheet view that has a yes/no check box how do I have the data show as yes or no and not a check box?

Thanks

Ron

In your query that drives the form:

Since a checkbox generates a 0 for no and a -1 for yes:

IIF([yourcheckboxfield}=-1,"yes","no")

I apologize for my inexperience but how do I identify the query that drives my form?

Go to design view on your from (right click select design view)

In the upper left hand corner click on the box. The box should turn black.

Now right click on the box and select properties.

Look for the controlsource property. That should tell you what is controlling the form.

Good Luck!

Also note that Milton had a typo in his code:

IIF([yourcheckboxfield}=-1,"yes","no")

should be

IIF([yourcheckboxfield]=-1,"yes","no")


Linq ;0)>

Thanks!

I fat fingered that one!

Milt

Thanks for the quick responces.

I did not see a Control Source property but the Record Source is a table and the Record Set Type is Dynaset.

OK, the recordsource is a table and you need to build a query to drive it from.

Use the query builder and drag the field names down.

Then use the IIF staement I gave you in one of the fields.

If you have trouble, post back.

Good luck!

I’m apparently making this a harder than it should be.

This is what I tried. In design view of the form > properties > record source > using query builder I dropped the fields in the query I want in the form. I entered the statement you provided, using my checkbox field name, in one of the field cells. I saved and closed. When I open the form in datasheet view the check box is still visible rather than yes or no. What am I doing wrong?