ListBox (Value List) - Limit / Limitations (2048 Characters)

[Cosmos75]

I have a ListBox that has its Row Source Type set to Value List. The values are populated with code. I did run into a problem, for one case I get an error.

Error #: 2176
Error Description: The setting for this property is too long.


So, I look in the limitations for a form and find this.

Maximum Number of characters in a label: 2,048

The length of what did get populated in the listbox is 2,047


So I guess that is the limit for a listbox (value list).


Just thought I'd pass this information along.

What I think I'll end up doing is to write records to a table and set the RowSource of the ListBox to that table instead.

 

[dcx693]

FYI: The character limit in Access 2002 has been increased to 32,786. See the following article for more info on list filling: New List-Filling Options in Access 2002