?
Solved

Can a combobox be made multi-select in ACCESS 2010

Posted on 2013-12-18
5
Medium Priority
?
19,096 Views
Last Modified: 2013-12-18
I have several forms that are short on real estate, is there a way to make a combobox multi-select?

Sandra
0
Comment
Question by:ssmith94015
[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
  • 2
5 Comments
 
LVL 42

Accepted Solution

by:
pcelba earned 2000 total points
ID: 39728012
Obvious answer:
You cannot select multiple values in a combo box. Use a list box instead. You will find the Multi Select property in Properties, tab Other.  MultiSelect property = 1 (Simple) or 2 (Extended).

Possible solution for combo: http://office.microsoft.com/en-us/access-help/use-a-list-that-stores-multiple-values-HA010031117.aspx
And some more info about: http://stackoverflow.com/questions/16598991/ms-access-multi-select-combo-box-select-all-none
0
 

Author Comment

by:ssmith94015
ID: 39728026
That is the problem, I have no space for a listbox as mentioned in my question and was hoping for a workaround.
0
 
LVL 42

Expert Comment

by:pcelba
ID: 39728039
Yes, I understand that. And the solution is in the first link. It displays the list when needed only.
0
 
LVL 61

Expert Comment

by:mbizup
ID: 39728041
Use tab controls to handle the form real estate problem by grouping related controls together on separate tabs.
0
 

Author Closing Comment

by:ssmith94015
ID: 39728057
Sorry, I am so tired I did not realize what you had provided.  This helps a lot as my deadline is tomorrow and I have not slept for two days now.

Sandra
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

777 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