Error: 2176 for form listbox when row source Type is set to "Value

Error: 2176 for form listbox when row source Type is set to "Value

am 26.11.2007 12:38:17 von m-sjoblom

Hi
On a form listbox Access version 2003 has a limited number or
characters that can be stored in a listbox when the Row source Type is
set to "Value List".
Is there anybody that knows the limitation and is it possible to
increase the "buffer" with a parameter.

Re: Error: 2176 for form listbox when row source Type is set to "Value List"

am 26.11.2007 13:01:41 von Stuart McCall

wrote in message
news:4777926e-0380-4166-b3a1-023494424e1b@j44g2000hsj.google groups.com...
> Hi
> On a form listbox Access version 2003 has a limited number or
> characters that can be stored in a listbox when the Row source Type is
> set to "Value List".
> Is there anybody that knows the limitation and is it possible to
> increase the "buffer" with a parameter.

32768 characters allowed. Buffer size is fixed.