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"
 
Back
Top