Dropdown List Limitation

Ivkosky

Registered User.
Local time
Today, 15:34
Joined
Feb 21, 2009
Messages
12
Hi,


I am quite new to Access. I found out, that there is a limit of 250 rows per dropdown list. Can I overcome it somehow? I need to have 281 rows. I used lookup table with just one field as a list of these entries and then made a relationship using lookup wizard between the main table, where the dropdown list field has to be settled, and the lookup table. Thank you for your advices,


Ivan
 
why do yuo think there is a limit of 250 rows - there isnt a limit as far as i am aware, but long combo boxes/list boxes are generally best avoided if possible
 
there is a limit of 255 columns per table not rows
 
Thank you,


you are right. There's no limit to the rows. However I still have the same problem. I get two error messages when I try to save the table after I did the dropdown list using the lookup wizard. I did the screenshots if you want to take a look. Thank you once more,


Ivan

Error Msg 1.JPG

Error Msg 2.JPG
 
I strongly advise you to remove combo boxes from tables. Place your combo box on a data entry form instead. Always try and keep tables as simple as possible, with minimal index's, one on Your primary key and one on any Foreign keys in your table.
 
You are right, thank you very much. Unfortunately in this case I can't avoid combo box. Thanks once more.
 

Users who are viewing this thread

Back
Top Bottom