Re: How to get matching values with list box and dropdown property?

From: Douglas J. Steele (
Date: 07/25/04

Date: Sun, 25 Jul 2021 09:25:07 -0400

Gee, did you ask this in enough groups? This has absolutely nothing to do
with ActiveX controls, command bars, conversion, data access pages, the
developer's toolkit nor (I suspect, since I can't see all of the groups to
which you posted this) most of the other groups to which you posted this

It sounds as though you're talking about a combo box, not a list box. List
boxes don't have a dropdown property, at least not in Access.

If what you're trying to do is allow them to type bcd in the box of the
combo box, and have it find abcdef as a possible match, I don't believe it
can be done.

If what you want is have them type bcd into a separate text box, and then
have the combo box limited to only those records which match what was typed
into the text box, base the combo box on a query that includes a Where
clause along the links of LIKE "*" & [Forms]![FormName]![TextBox] & "*",
where you need to replace FormName and ListName with the appropriate names.

Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Jack Darsa" <> wrote in message
> Hello,
> 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
> abcdef
> abdeg
> abchi
> bcdef
> 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 ?
> Jack