Yes/No data type conversion to Text for display

  • Thread starter Thread starter rs0905
  • Start date Start date
R

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!
 
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!
Click to expand...

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying Yes/No as Yes or No instead of -1 and 0 1
Listbox display 0/-1 r/t Yes/No 3
Displaying Yes/No as Yes or No instead of -1 and 0 2
How to display a comma in an unbound listbox. 3
Datasheet caption for yes/no field can't be changed 1
Can I make a number field show as yes/no in a listbox? 4
How Do I display a Yes/No Field correctly in a List Box? 2
split form Yes/NO 1

Back
Top