Yes No Combo Boxes

[Guest]

Hi guys.

I've created a query for which various combo boxes determine the results
displayed from the query.

I have a combo box with the options Yes/No - in order to get this to work I
have to have 2 columns and two rows.

0; "No"; -1 "Yes"

Is there anyway to get this to work without having to have the 0 and 1 in
there. I simply just want the combo box to contain 1 columna and the fields
Yes and No - but obviously I want the query to still read these as a 0 and a
-1.

 

[Allen Browne]

Try setting these properties:
Format Yes/No
Row Source Type Value List
Row Source Yes;No
Column Count: 1

Setting the Format property should be enough to trick Access into
understanding the data type as boolean.

 

[Guest]

Allen - that worked perfectly.

Once again - thank you ever so much.