Combo box wont display Yes/No value

  • Thread starter Thread starter ExcelMan
  • Start date Start date
E

ExcelMan

I have a combo box with 2 columns. The RowSource is a value list as
follows:

No;Asc;Yes;Desc

The ColumnCount is set to 2 and the ColumnWidth is 0";0.5". The BoundColumn
is set to 1.

The ControlSource is set to a field in the form recordsource. The combobox
works fine when the field datatype is set to Text. When I change the
underlying field to a boolean (Yes/No) the combobox passes the data to the
table fine, but it doesn't display the "Asc" or "Desc" that it should when
the user selects.

What is going on? Why can't I have a display column that is text when the
bound column is a boolean?
 
Back
Top