Yes/No Box in Query showing as Zero instead of a Check Box

Any clue how to get this back to showing a check box?
Who is Participating?
mbizupConnect With a Mentor Commented:
In your query's Design view, right-click the field in question and click "Properties"

In the field's Property Sheet, verify that the "Display Control" property is set to Check Box.

Check Box
Are you sure the column you are referring to is used in your query directly? I think when you use an expression (something like Val([Column1])) then the value is displayed as a Number (0 for No, -1 for Yes)
daisypetals313Author Commented:
It is a linked query...would that be causing the issue?
daisypetals313Author Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.