Format of yes/no data in textbox.

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a Text Box that reads a Combo Box and displays data. Column(8) is
Yes/No data.

In the "Control Source .... =[cboUsContactBillto].Column(8)"
The data in in Column(8) is from a combobox and this is from a db table. All
of which display the data properly.
In the database table the field shows up nicely as a check box, as it does
in a dropdown box combobox. But when the information is displayed in the
above "Control Source .... =[cboUsContactBillto].Column(8)"
It is displayed as -1 for Yes and 0 for No.
How can I display this data as Yes or No rather than -1 and 0.
I have tried a varety of formats but this does not work. In another column
where I have phone numbers I use !(@@@) @@@-@@@@ which works find. What
should I use for yes/no?

Thanks
 
Try changing the ControlSource to something along the lines of

=IIf([cboUsContactBillto].Column(8),"Yes","No")

Hope That Helps
Gerald Stanley MCSD
 
I have a Text Box that reads a Combo Box and displays data. Column(8) is
Yes/No data.

In the "Control Source .... =[cboUsContactBillto].Column(8)"
The data in in Column(8) is from a combobox and this is from a db table. All
of which display the data properly.
In the database table the field shows up nicely as a check box, as it does
in a dropdown box combobox. But when the information is displayed in the
above "Control Source .... =[cboUsContactBillto].Column(8)"
It is displayed as -1 for Yes and 0 for No.
How can I display this data as Yes or No rather than -1 and 0.
I have tried a varety of formats but this does not work. In another column
where I have phone numbers I use !(@@@) @@@-@@@@ which works find. What
should I use for yes/no?

Thanks
Click to expand...

In the Format Property line for this control, write:
#;"Yes";"No"

Look up the
Format Property + Number and Currency Datatypes
in Access help.
 
Back
Top