cannot add to lookup column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Ed said:
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
Click to expand...

Change to a lookup table. ValueLists have a limited length.
 
Douglas J. Steele said:
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.
Click to expand...

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
 
Back
Top