I have a combobox on a form that allows user to select multiple items from the drop down. I now need to change it so user can select only one item. How do I do that?
Thanks
I have a combobox on a form that allows user to select multiple items from the drop down. I now need to change it so user can select only one item. How do I do that?
Thanks
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
Is the combobox bound to a multi-value field?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I am using Access 2021, trying to stay out of VBA, but do not see multi select as an option on property sheet. What am I missing here?
I am using Access 2010, trying to stay out of VBA, but don't see multi select on property sheet for the field.
Listboxes allow multi-select but not comboboxes ...with one exception.
If you have multivalued fields (MVFs), comboboxes will display a series of checkboxes from which one or more values can be chosen.
However using MVFs is considered to be a VERY BAD IDEA by most developers. See Multivalued fields ...and why you shouldn't use them
If you designed the form then what follows has about a zero percent chance of being applicable.I have a combobox on a form that allows user to select multiple items from the drop down
Listbox multi-select property is on the Other tab of the property sheet. Maybe you have a listbox that was designed to behave like a combo (i.e. expand vertically).
IIRC, even a combo bound to a mv field does not have the multi-select property available.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Yes it doesIf you designed the form then what follows has about a zero percent chance of being applicable.
Listbox multi-select property is on the Other tab of the property sheet. Maybe you have a listbox that was designed to behave like a combo (i.e. expand vertically).
IIRC, even a combo bound to a mv field does not have the multi-select property available.
I didn't say it wasn't multi select, I said the property was not available. Since you have one to play with and I don't can you confirm the property is available in the property sheet?IIRC, even a combo bound to a mv field does not have the multi-select property available.
Thanks.
EDIT - in other words, if the property was available (read that as not read-only) then you would be able to set it to no - not that would make a whole lot of sense to do so.
My point was for the OP to search the property sheet and see if that property was there for his/her combobox. I'm saying it's probably not there.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Sorry about thatI didn't say it wasn't multi select, I said the property was not available. Since you have one to play with and I don't can you confirm the property is available in the property sheet?
Thanks.
EDIT - in other words, if the property was available (read that as not read-only) then you would be able to set it to no - not that would make a whole lot of sense to do so.
My point was for the OP to search the property sheet and see if that property was there for his/her combobox. I'm saying it's probably not there.
You are indeed correct. The property doesn't exist even for a combobox based on a multi valued field