Re: How to get matching values with list box and dropdown property?
From: Ron Weiner (weinNoSpam1_at_mindspring.com)
Date: Sun, 25 Jul 2021 09:37:42 -0400
List Boxed do NOT have a DropDown Property. Sounds like you want a list box
whose row source is controled by a text box. All you need to do is change
the list box row source using the value in the text box. For example:
lstYourListBox.RowSource = "Select YourColumm From YourTable Where
YourColumn Like '*" & txtYourTextBox.Value & "*' Order By YourColumn;"
Should give the results you want.
"Jack Darsa" <email@example.com> wrote in message
> I want to define a list box with dropdown property, but i don't want to
> limit the choices the the first character only ,but to any consecutive
> characters typed by the user. For example:
> if the list contains
> The outcome should be:
> input value shown from the list (rows)
> b 1,2,3,4
> bc 1,3,4
> bcd 1,4
> In this example the list is not limited only to the first characters , but
> to any string with the typed characters.
> Anybody can help me ?