How to show checkbox in combobox?
  Home FAQ Contact Sign in
microsoft.public.access only
 
Advanced search
POPULAR GROUPS

more...

microsoft.public.access Profile…
 Up
How to show checkbox in combobox?         


Author: WDSnews
Date: Jan 28, 2010 19:07

The parent table has a boolean field. If I use it in the combobox of a
child form, the display shows 'Yes' or 'No' rather than the checkbox I want
to see.
2 Comments
RE: How to show checkbox in combobox?         


Author: Lynn Trapp
Date: Jan 28, 2010 19:51

Regular combo boxes can only display the actual value stored in your row
source, not the checkbox display. If you have A2007, you can use a
multi-valued combobox and it will show checkboxes.

--
Lynn Trapp
MCP, MOS, MCAS

"WDSnews" wrote:
> The parent table has a boolean field. If I use it in the combobox of a
> child form, the display shows 'Yes' or 'No' rather than the checkbox I want
> to see.
>
>
> .
>
no comments
Re: How to show checkbox in combobox?         


Date: Jan 28, 2010 20:04

I don't think there's any way you'll show check boxes as such in a combo box.
The nearest you could get would be to use the usual method for simulating
check boxes of a size/format different from the default in a form by setting
the FontName property of the combo box to Wingdings and in its RowSource use
a computed column to return the relevant character for a tick, e.g.

SELECT IIf([MyBooleanField],Chr(252),"")
FROM MyTable;

That will give you a tick for each True and a blank for each False, but you
won't get a box around them as you can to simulate a single check box in a
form or report by using a text box based on the computed column.

Ken Sheridan
Stafford, England

WDSnews wrote:
>The parent table has a boolean field. If I use it in the combobox of a
>child form, the display shows 'Yes' or 'No' rather than the checkbox I want
>to see.

no comments