Multivalue selection control has no check boxes.

I want to create a check-box combo-box multivalue control on an Access2007 form, but the control appears without the check boxes.
Wadley1957Asked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
...just to be sure...

You do know that the checkbox in a multi-valued field will only appear when the list is "dropped down"?
(This is stated in the link you posted...)
untitled.JPG
0
 
dqmqCommented:
>I want to create a check-box combo-box multivalue control


A what?
A list box can be multi-valued
A series of check-boxes can be multi-valued
But I've never heard of what you are asking about
0
 
Wadley1957Author Commented:
I think what I want is a listbox control from which I can select multiple items by left-mouse click. Also want to de-select by reclicking a previously selected item. When I try to create a field a table with the Lookup Field Wizard, I do not see the option to "allow multiple selection" at the end of the Wizard.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
dqmqCommented:
A listbox on a table field cannot be multi-valued because the selected item becomes the value of the field.  A field can only have one value.  A listbox control can be multi-valued because you handle the multiple selections programatically.
0
 
Wadley1957Author Commented:
Okay. Cannot, however, a table in Access2007 maintain a lookup-type field which acts like a typical data field, but is capable of assembling compound data items, delimited by commas by default, which it collects from a user interaction with a series of data elements stored in internally maintained subordinate lookup tables and available to users through a listbox control that presents check boxes before each of the available data items and alows a choice of more than one item?
0
 
Jeffrey CoachmanMIS LiasonCommented:
Most developers do not use these new multivalued fields.
They have issues.
See here:
http://allenbrowne.com/Access2007.html#Mixed
http://www.theregister.co.uk/2006/07/18/multivalued_datatypes_access/
http://www.pcreview.co.uk/forums/multivalued-field-join-clause-problems-access-2007-a-t3869977.html
http://www.dbforums.com/database-concepts-design/649369-multivalued-field-seach-problems-cont.html
http://splunk-base.splunk.com/answers/11703/problems-comparing-multivalue-fields
http://www.accessmonster.com/Uwe/Forum.aspx/access-queries/47010/subreport-problems-with-multivalued-fields
...etc

Since you did not post any info on your table, ...or the fields, ...or the properties,  or posted a sample for us to examine, ...
...it is difficult to say what went wrong.

Instead of referencing a link describing how to *use* these fields, why not view a link that shows how to *create* them?
http://office.microsoft.com/en-us/access-help/guide-to-multivalued-fields-HA001233722.aspx#BM4
When I tried this it worked fine.

;-)

JeffCoachman
0
 
Wadley1957Author Commented:
Hi, Jeff. Actually, I was only considering upgrading some forms that I use a lot and saw the posibility of exploiting this technique. I had not put down any code as yet. I'm currently using a dozen discrete Y/N fields of the bound table to collect the user's selections and from this I build a simple string for the particular report by concatenation. It works fine. Just thought I'd try something snazy. Appreciate the help!
--Greg
0
 
Jeffrey CoachmanMIS LiasonCommented:
...so make sure you note step 8 in the link I posted:

   8. Under Do you want to store multiple values for this lookup?, select the Allow Multiple Values check box.

 Note   This check box must be selected to enable storing multiple values.

JeffCoachman
0
 
Wadley1957Author Commented:
Thanks to all!
0
 
Jeffrey CoachmanMIS LiasonCommented:
Yes, they are snazzy, but again, ...they have issues.

If you must use them, use them in your forms only (not in the table) and only for *simple* designs.

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.