String too long I guess!
Posted on 2002-03-26
I use a procedure to create a listbox that shows all the queries in a database, so the user can select a query to run.
In testing, I ran into error 2176, something about "The text you are putting in this field is the wrong size, it must be either 255 or 2048 bytes...." (I'm paraphrasing there!)
I set the list box for ROwSource=ValueList.
The DB I was using had LOTS of queries, so maybe the list was too big. Anyway to handle this? I suppose, the string I build containing queries, I could split into 200 char chunks, and display them thusly....And why do some queries come up with wierd names that I can't see in the DB window (things like ~sqqryWhatItIs).