Solved

Access Userform Matchentry

Posted on 2014-01-03
2
432 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:Massimo Scola
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:Massimo Scola
ID: 39754024
Thanks for the information. I'm going to use comboboxes instead.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

735 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