By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,030 Members | 1,207 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,030 IT Pros & Developers. It's quick & easy.

Combo box issue on Microsoft Access 2010

P: 11
I am using Microsoft Access 2010 for a database and I have a list of approximately 700 keywords that I want to add into the dropdown list of a combo box. I have copied and pasted all the words into the values list but only 105 show up. When I try to add another list item to the dropdown menu, the result will not show, implying that I have a full list. I was under the impression that combo boxes could hold more values than that. Could someone help me with this issue? Thanks a lot.
Mar 2 '15 #1

✓ answered by twinnyfo

amwkl4,

The best way to do this is to have your list of values in a table, and then create a query based on that table. The combo box then uses that query as its row source. (instead of a Value List, it should be A Table/Query for RowSourceType).

Hope this hepps!

Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,488
amwkl4,

The best way to do this is to have your list of values in a table, and then create a query based on that table. The combo box then uses that query as its row source. (instead of a Value List, it should be A Table/Query for RowSourceType).

Hope this hepps!
Mar 2 '15 #2

P: 11
Thank you very much! Its displaying all the values now.
Mar 2 '15 #3

twinnyfo
Expert Mod 2.5K+
P: 3,488
Great! I'm glad I could be of service!
Mar 2 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.