Multi Value Combo Boxes - Microsoft Access Expert 1


	Back to Access Expert 1 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multi Value Combo Boxes

John Schulte

5 years ago

Is there a way to pick multiple values of a dropdown list. As an example; A customers preference is to ship UPS first and them USPS, but I'd like that to show in the same field with just a comma between them.

Thanks!

	Alex Hedley @Reply 5 years ago
How about a MultiSelect ListBox Access Developer 15

Kevin Robertson @Reply

5 years ago

If you need your list of values in a textbox separated by commas for display purposes,  you could try something like this:

    Private Sub btnAdd_Click()

        Dim S As String

        S = ""

        S = ComboBox.Column(1)
        TextBox = TextBox & ", " & S
        If Left(TextBox, 2) = ", " Then
            TextBox = Right(TextBox, Len(TextBox) - 2)
        End If

    End Sub

Also, since you are a Gold Member you have access to  the Code Vault. Check out Richard's DLookUpPlus function.

	Richard Rost @Reply 5 years ago
I wouldn't use multi-valued fields. For this I would actually recommend a related table and a subform. Then you could pick each shipping method AND put a "1, 2, 3" next to them for order of preference.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 1.

Next Unseen