Multi-select list boxes

[cd]

With a multi-select list box, do you need additional code
to store the multiple selections in the bound field or is
that possible at all? i.e., I set a text box to Multi-
select-simple and set the Control source to the field in
my table. If I select one value from the list it is stored
in the table, but if I select more than one value nothing
is stored. I realize that this implies we may not have a
normalized database but it's the best solution for our
purposes. I appreciate the assistance if someone as some
ideas.

 

[Ki Yi [MS]]

Hello,

This is a defualt behavior. You can get around this problem using VBA code.
See following article for sample:


ACC2000: Bound Multi-Selection List Box Always Returns Null WGID:147
ID: 210203.KB.EN-US
http://support.microsoft.com/default.aspx?scid=kb;en-us;210203

Regards,

Ki Yi
Microsoft Support

This posting is provided AS IS with no warranties, and confers no rights.

 

[Van T. Dinh]

Multi-Select ListBox *always* has Null Value so if you bind a Field to the
Multi-Select ListBox, you always get Null.

You will ned to use the "ItemsSelected" Property of the ListBox and code to
manipulate the selections in a list (comma separated, perhaps).

The code (to create the comma-separated list) should be something like:

****Untested****
Dim strList As String
Dim varItem As Variant

strList = ""
For Each varItem In Me.ListBoxName.ItemsSelected
strList = Me.ListBoxName.ItemData(varItem) & ","
Next varItem

If (Len(strList) > 0) Then
strList = Left(strList, Len(strList) - 1)
End If
****Code ends****

(Note: this is NOT the way I usually store data but you are aware of the
unnormalised problem)

HTH
Van T. Dinh
MVP (Access)