Value List Combo Box Lookup for boolean field?

[Dick Watson]

I want to define a Lookup for a Boolean field that uses a Combo Box and a
Value List to mask the data type and present information in a more usable
form--i.e., "Satisfied" stores True, "Not Satisfied" stores False. I can't
seem to get the Combo Box to show my labels when pulled down. I've tried
four values in the list for a two column Combo Box with the first column of
zero width, but it whines about the data being invalid for the field. How
can I do this?

Thanks for any suggestions!

 

[John Vinson]

I want to define a Lookup for a Boolean field that uses a Combo Box and a
Value List to mask the data type and present information in a more usable
form--i.e., "Satisfied" stores True, "Not Satisfied" stores False. I can't
seem to get the Combo Box to show my labels when pulled down. I've tried
four values in the list for a two column Combo Box with the first column of
zero width, but it whines about the data being invalid for the field. How
can I do this?

Thanks for any suggestions!

A Yes/No field is stored with -1 for Yes, 0 for No. So try the
following properties:

Row Source Type: Value List
Row Source: -1;"Satisfied";0;"Not Satisfied"
Column Count: 2
Bound Column: 1
Column Widths: 0;.75
Control Source: (the name of the yes/no field)


John W. Vinson[MVP]