Solved

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

Posted on 2014-01-05
4
291 Views
Last Modified: 2014-01-17
Any clue how to get this back to showing a check box?
0
Comment
Question by:daisypetals313
  • 2
4 Comments
 
LVL 24

Expert Comment

by:chaau
ID: 39758403
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
 

Author Comment

by:daisypetals313
ID: 39758452
It is a linked query...would that be causing the issue?
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 39758881
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
 

Author Closing Comment

by:daisypetals313
ID: 39789271
Thanks!!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access 2016 5 53
Programmer 14 47
Calculate workdays and consider holidays database from microsoft 2007 8 22
Field naming convntions - MS Access 7 20
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question