<div>
if the field where the checkbox is bound is a YEsNo field, use a query to convert the values to Yes No.
</div>


<div>
select iif([chk1]=-1,&quot;Yes&quot;,&quot;No&quot;) from tablename
</div>


<div>
Currently it's just a text field. &nbsp;If I change them to a yes/no field then what would I put in the query?<br />
<br />
Regards<br />
<br />
Chris
</div>


<div>
Where you like to see Yes and No? Create Additional table with two columns and twi text fields:<br />
-1 Yes<br />
0 &nbsp;No<br />
join your table with this one and display Yes and No everywhere
</div>


<div>
<blockquote>
select iif([chk1]=-1,&quot;Yes&quot;,&quot;No&quot;) from tablename 
</blockquote>
<br />
Hi capricorn1.<br />
<br />
The field on the form is just stating #Name? when I do this?<br />
<br />
Regards<br />
<br />
Chris
</div>


<div>
post the <b>real SQL</b> statement that you are using.
</div>


<div>
there must be some check boxes that are null.<br />
set the default value for all the check box fields to 0 (false)
</div>


<div>
Try with:<br />
<br />
select iif([chk1]=-1,&quot;Yes&quot;,&quot;No&quot;) as chkyesno from tablename <br />
<br />
Then bind your textbox to [chkyesno]<br />
<br />
Still, it is much easier and preferable just to set the Format property of the textbox.<br />
<br />
/gustav<br />
<br />

</div>


<div>
Sorry Cactus! I totally didn't understand what you meant and I've just figured it out! Such an easy solution! <br />
<br />
Thanks
</div>


<div>
No problem. You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Following on from my previous question: &nbsp;<br />
<br />
<a href="https://www.experts-exchange.com/questions/27047167/How-do-I-edit-this-code-to-enable-check-boxes.html" rel="ugc">https://www.experts-exchange.com/questions/27047167/How-do-I-edit-this-code-to-enable-check-boxes.html</a><br />
<br />
When the checkbox access stores a Yes as -1 or a No as 0<br />
<br />
I need it to be displayed in a different form as either Yes or No<br />
<br />
Is there some code to put on the checkboxes that would store it as Yes or No or do I use a query to convert the answer stored in the table to Yes or No?
</div>
</div>


Hi,

Following on from my previous question:  

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27047167.html

When the checkbox access stores a Yes as -1 or a No as 0

I need it to be displayed in a different form as either Yes or No

Is there some code to put on the checkboxes that would store it as Yes or No or do I use a query to convert the answer stored in the table to Yes or No?

How to display yes/no if value is -1 / 0

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.