cannot add to lookup column

[Ed G]

Created a value list and use edit list to add data. After 150 entries, it
won't allow me to add any more. Please help

 

[Douglas J. Steele]

There is a limit to how long the string that comprises the value list can be
(sorry, I don't remember it off the top of my head).

Hopefully you're aware that many of us feel that using lookup fields is a
mistake. Take a look at http://www.mvps.org/access/lookupfields.htm for some
of the reasons why.

 

[Rick Brandt]

Created a value list and use edit list to add data. After 150
entries, it won't allow me to add any more. Please help

Change to a lookup table. ValueLists have a limited length.

 

[RoyVidar]

There is a limit to how long the string that comprises the value list
can be (sorry, I don't remember it off the top of my head).

Hopefully you're aware that many of us feel that using lookup fields
is a mistake. Take a look at
http://www.mvps.org/access/lookupfields.htm for some of the reasons
why.

I think the limitations are as follows

2 048 characters for 2000 and earlier versions
32 750 characters for 2002/2003 version

I don't know anything for 2007 version, but I doubt it is less than
2002/2003

 

[Ed G]

Thank you.

There is a limit to how long the string that comprises the value list can be
(sorry, I don't remember it off the top of my head).

Hopefully you're aware that many of us feel that using lookup fields is a
mistake. Take a look at http://www.mvps.org/access/lookupfields.htm for some
of the reasons why.