Search in combo box

[Abdul Shakeel]

In a form I have a combo box listed seven thousand of inventory item in
ascending order, sometimes it becomes very difficult to reach on a specific
inventory item, typing the name of the inventory item is also not so use full
as the name of the inventory having almost same character for example:
C1 UM UDR 1 1/0
C1 UM UDR 1 1/1
and so on, so I want to search item on combo box by typing less is there any
way to do this.

 

[Arvin Meyer [MVP]]

If there is significant commonality in the inventory items, you could use
the Left, Mid, and Right functions to build multiple combo boxes and drill
down to your final record. In the example below, you could save as many as 4
characters. I'm not sure that the effort required is worth the result.

 

[Klatuu]

In addition to Arvin's suggestion, you may consider using Cascading Combos if
the items have a category or grouping you can use to reduce the search.

 

[KARL DEWEY]

Checkout the combo Auto Expand property. It scrolls to the value or part of
the value as you type in the combo.