collection and limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

--== Alain ==-- - 16 Dec 2006 12:49 GMT

Hi,

I have a collection object and it seems limited to 256 items.
How is it possible to increase this limit ?

thanks a lot,

Al.

Reply to this Message

Peter T - 16 Dec 2006 13:56 GMT

> Hi,
>
> I have a collection object and it seems limited to 256 items.
> How is it possible to increase this limit ?

Sub test()
Dim i As Long
Dim col As Collection

Set col = New Collection
For i = 1 To 20000
col.Add i, CStr(i)
Next

MsgBox col("20000")

End Sub

Is there something special about your particular collection

Regards,
Peter T

Reply to this Message

--== Alain ==-- - 17 Dec 2006 08:54 GMT

It's a simple collection with 21000 records...nothing special

>> Hi,
>>
[quoted text clipped - 18 lines]
> Regards,
> Peter T

Reply to this Message

RichardSchollar - 17 Dec 2006 12:46 GMT

Alain

How are you creating your collection? Can you post the code you have?

Richard

> It's a simple collection with 21000 records...nothing special
>
[quoted text clipped - 20 lines]
> > Regards,
> > Peter T

Reply to this Message

JLGWhiz - 17 Dec 2006 22:15 GMT

I am beginning to wonder if Alain is a real person or a virus.

> Alain
>
[quoted text clipped - 26 lines]
> > > Regards,
> > > Peter T

Reply to this Message

--== Alain ==-- - 18 Dec 2006 13:21 GMT

Sorry but i'm not a virus !

> I am beginning to wonder if Alain is a real person or a virus.
>
[quoted text clipped - 28 lines]
>>>> Regards,
>>>> Peter T

Reply to this Message

jeff.j.griffith@gmail.com - 18 Dec 2006 13:34 GMT

It's not the collection that's limited, but the Watch window. I've
added well more than 256 items to collections, only to be tricked by
what displays in the watch window.

> Sorry but i'm not a virus !
>
[quoted text clipped - 30 lines]
> >>>> Regards,
> >>>> Peter T

Reply to this Message