Display check boxes in combo boxes

[MontgomeryPete]

I have a combo box that enables selection of a particular record. The SELECT statement selects seven fields that are defined as YES/NO, after the key field.

Does anyone know of a way to display the YES/NO values as checkboxes (easier for user to read), rather than "YES" or "NO"?

Thanks

Pete

 

[Remou]

You can use Display Control on the Lookup property sheet in table design view, or you can create a checkbox control and bind the relevant fields.

 

[CautionMP]

MontgomeryPete,
Use a Microsoft Forms 2.0 ListBox control?

Pros: If you set the ListStyle to Option and enable MultiSelect all the items will have check boxes next to them, which sounds like what your looking for.

Cons: The control does not have all the fancy recordset stuff that an Access ListBox does so you would need to populate the list with code using the AddItem and Selected properties.

Hopes this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[MontgomeryPete]

Thanks to both Remou and CMP for your help. I finally ended up making a checkbox control and displaying the items that way.

Appreciate your prompt response.

Pete