Yes/No data type conversion to Text for display

[rs0905]

I have a checkbox control that stores in a table as a checkbox (y/n). When
queried, it returns 0 and -1. I need to include the result of this field in
a column in a listbox on a separate form. Instead of displaying as 0 and -1,
I need it to display in the listbox as Yes and No. How do I do this!

Thanks!

 

[rs0905]

Thanks - I hadn't thought of that!

Take a look at the format of that field in the table. I believe you can
have it display as a Yes/No.

Or you can create a query that includes a new field in which you "calculate"
a "Yes" if <>0 and a "No" if =0.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jeff Boyce]

Take a look at the format of that field in the table. I believe you can
have it display as a Yes/No.

Or you can create a query that includes a new field in which you "calculate"
a "Yes" if <>0 and a "No" if =0.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson/MVP]

I have a checkbox control that stores in a table as a checkbox (y/n). When
queried, it returns 0 and -1. I need to include the result of this field in
a column in a listbox on a separate form. Instead of displaying as 0 and -1,
I need it to display in the listbox as Yes and No. How do I do this!

Thanks!

One way is to use the following listbox properties:

Control Source: <your yes/no field>
Row Source Type: Value List
Row Source: -1;"Yes";0,"No"
Column Count: 2
Column Widths: 0";0.25"