asked on

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

Hi,

Following on from my previous question:

https://www.experts-exchange.com/questions/27047167/How-do-I-edit-this-code-to-enable-check-boxes.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?

Rey Obrero (Capricorn1)

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

Rey Obrero (Capricorn1)

select iif([chk1]=-1,"Yes","No") from tablename

smods

ASKER

Currently it's just a text field. If I change them to a yes/no field then what would I put in the query?

Regards

Chris

Rey Obrero (Capricorn1)

see my second post.

als315

Where you like to see Yes and No? Create Additional table with two columns and twi text fields:
-1 Yes
0 No
join your table with this one and display Yes and No everywhere

ASKER CERTIFIED SOLUTION

Gustav Brock

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

smods

ASKER

select iif([chk1]=-1,"Yes","No") from tablename

Hi capricorn1.

The field on the form is just stating #Name? when I do this?

Regards

Chris

Rey Obrero (Capricorn1)

post the real SQL statement that you are using.

Rey Obrero (Capricorn1)

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

Gustav Brock

Try with:

select iif([chk1]=-1,"Yes","No") as chkyesno from tablename

Then bind your textbox to [chkyesno]

Still, it is much easier and preferable just to set the Format property of the textbox.

/gustav

smods

ASKER

Sorry Cactus! I totally didn't understand what you meant and I've just figured it out! Such an easy solution!

Thanks

Gustav Brock

No problem. You are welcome!

/gustav