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?
daisypetals313Asked:
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
0
 
chaauCommented:
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)
0
 
daisypetals313Author Commented:
It is a linked query...would that be causing the issue?
0
 
daisypetals313Author Commented:
Thanks!!
0
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.