G Guest Feb 17, 2007 #1 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
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
D Douglas J. Steele Feb 17, 2007 #2 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.
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.
R Rick Brandt Feb 17, 2007 #3 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.
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.
R RoyVidar Feb 17, 2007 #4 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
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
G Guest Feb 17, 2007 #5 Thank you. 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...
Thank you. 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...
