Solved

Access Userform Matchentry

Posted on 2014-01-03
2
403 Views
Last Modified: 2014-01-03
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
Comment
Question by:mscola
2 Comments
 
LVL 6

Accepted Solution

by:
ButlerTechnology earned 500 total points
ID: 39753581
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
 

Author Closing Comment

by:mscola
ID: 39754024
Thanks for the information. I'm going to use comboboxes instead.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now