Combo Box Value List

G

Gene

I've run across it before but I can't find it now. Access 2000 only allows
so many characters in a value list for a combo box. I believe it's around
2000 characters. Anyone know for sure. I want to code and return the max.
characters if the string is to long.

Thanks
 
B

boblarson

If you get that many characters in a value list you should be using a table
instead. Why wouldn't you just use a table for them in that case?
--
Bob Larson

Tutorials at http://www.btabdevelopment.com

__________________________________
 
G

Gene

Normally the list are very short. This is an exception. I'm appending a
couple of items on the list as text in code, the rest of the list is
generated from a recordsort.getstring function. I'm not currently using 2000
or I would just increase the string size until I got the error.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

string variable value as default value for combo box 7
Using the not in list event 5
Combo box columns 1
Northwind Sales Dialog box- change combo to list box 5
Code to populate combo box 1
Re: Textbox character limit length 1
Why does Autoexpand in combo box not work with accented characters? 4
Run query to feed combo box 2

Top