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

26096

26097

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.

You are right, thank you very much. Unfortunately in this case I can't avoid combo box. Thanks once more.

In my opinion, you can ALWAYS avoid using the lookup field in a table. I really have NEVER had a need for them. Unfortunately, I have seen nothing but trouble from everyone that has tried to use them.

See: The Evils of Lookup Fields in Tables (http://www.mvps.org/access/lookupfields.htm)