Format of yes/no data in textbox.

[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

 

[Gerald Stanley]

Try changing the ControlSource to something along the lines of

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

Hope That Helps
Gerald Stanley MCSD

 

[steve]

Thanks that seemed to have done the trick.