Solved

Access Userform Matchentry

Posted on 2014-01-03
2
393 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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

747 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

11 Experts available now in Live!

Get 1:1 Help Now