• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • Last Modified:

Access Userform Matchentry

I've added a listbox on an Access userform.
Is there a way to select a listbox value the same way it is done in Excel?

Listbox Match Entry in Excel
I understand that there is a way to add Active-X controls on an Access userform, so I could make us of an ActiveX listbox.

Do you recommend adding ActiveX controls on a userform or should I stick with the regular Access controls?

Massimo
0
Massimo Scola
Asked:
Massimo Scola
1 Solution
 
ButlerTechnologyCommented:
A combo-box provides the features that allow the end-user to type in the value and it will start matching the text with the values in the list.  List boxes don't really have this functionality.  I have simulated the functionality with a textbox that would adjust the values in the list box based on the characters typed.

I would recommend staying with the provided access controls.
0
 
Massimo ScolaAuthor Commented:
Thanks for the information. I'm going to use comboboxes instead.
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now