Checkboxes in Listbox Possible?

[knlknl]

MS Access Checkboxes in Listbox Possible?
Would like to have display checkboxes in a listbox, so users can click what they want and then when click on Save button selected values of checkboxes will be stored in the MS Access table. Thanks.

[GazMathias]

No.

They always display as Yes/No in List Boxes, as far as I can tell.

Also, when you click an item in a list box, you are just collecting a value (or multiple values for multi selects) for later use.

With a bit of fancy formatting, I guess you could make a continuous form achieve what you want(in a subform, maybe).

Gaz

[NeoPa]

CheckBoxes & ListBoxes are controls in their own right, but neither is a type of object that can contain other controls (as say, forms and reports are).

I'm afraid what you ask makes little sense, but the answer's no anyway.

[knlknl]

Thanks for the reply.

Please look at the following link, and do get back. I did try but it did not seem to have that control in MS Access.

http://office.microsoft.com/en-us/access/HA100311171033.aspx#3

[NeoPa]

You're asking about a ComboBox with multiple columns within it?

[knlknl]

It would be good, too. But, I prefer checkbox list, and also wonder if it can be set up with MSAccess 2003.
Thanks,

[knlknl]

I prefer checkboxes with related contents (2 columns total) within a checkbox list (in a listbox), if possible.

If not, then combox with 2 columns (checkboxes and related lables) would do.
Thanks.

You're asking about a ComboBox with multiple columns within it?

[NeoPa]

It would be good, too. But, I prefer checkbox list, and also wonder if it can be set up with MSAccess 2003.
Thanks,

Now you're losing me again. I don't recognise what you're talking about :S

[knlknl]

Please go to : http://office.microsof t.com/en-us/access/HA100311171033. aspx#3 , and scroll down to almost half of the page until you see "The check box list is a list box control set to support multiple values." You may see check boxes along with related labels in the screenshot. That's what I am trying to set up.

Thanks.

[mshmyob]

Cannot be done in AC2003. Checkbox listboxes as described are based on Multivalued fields which were introduced in AC2007. Besides nobody in their right mind would use multivalued fields in their design.

cheers,

[NeoPa]

Please go to : http://office.microsof t.com/en-us/access/HA100311171033. aspx#3 , and scroll down to almost half of the page until you see "The check box list is a list box control set to support multiple values." You may see check boxes along with related labels in the screenshot. That's what I am trying to set up.

Thanks.

Aah. I see.

I'm afraid that I am no fan of Access 2007 so am mainly unfamiliar with the features there.

As Mshmyob says though, I guess it can't be done without Access 2007.

[knlknl]

Thanks. I just gave it a try to ensure if AC2003 can or cannot do.
This is a good object control that gives users to not use Ctrl+mouse-click when selecting items/records in the listbox. So, I can conclude that AC2003 can't but AC2007 can.

As the alternate, I use continuous form with checkboxes. I am able to multiple-select checkboxes, but labels of those checkboxes populates as the same one.
Can someone give a tip on how to list checkboxes with related labels?

For instance,
[x] United States
[x] United Kingdom
[x] France
[ ] Russia and
[ ] China in a continuous form.

Thanks

[NeoPa]

Only bound items can be different in a continuous form (Why Values in Unbound Form Controls Don't Persist). Hence the CheckBoxes are fine (bound to the record source), but the labels are not.

[NeoPa]

The only way I can think of to get around this is to include the label value (UK, USA, China etc) in the record source.

This means defining an UPDATABLE query (IIf() results no good I'm afraid) with matching label data in each record. This would then need to be shown on the form as a TextBox, but you would probably want to ensure the TextBox control is locked from editing.

[cybersmoker]

Multiselect Listbox

I know this thread is old but why not set the multi-select property of a list box to simple. It is selected and unselected by clicking the option desired.

It also provides the visual clue that it is "checked" by being high lighted.

Best yet, this option works for office as far back as 97 at least.

Hope this helps.