Problems with NewIndex property

[llafretaw]

Hi,
I'm having a problem with an application which preloads data into some of its comboboxes.
Basically once it hits 32,768 records it crashes out as the NewIndex property used with the ItemData property, goes from a value of 37,767 to -32768, is there any way of resetting its value back to zero or forcing it be a long integer as opposed to an integer?
Any help would be appreciated
Thanks

 

[mattKnight]

I would guess that the index property of a combo box is of type integer!

It begs the question, is a combo box with over 32 thousand choices really the most user friendly UI?

I'd get bored by about item 15 in the list....

Maybe some more information about what you are trying to do, in general terms, may allow someone to offer a better solution



Take Care

Matt
If at first you don't succeed, skydiving is not for you.

 

[MakeItSo]

Yepp, I doubt too, that you need all32k entries. A query as row source for the combo box that does a pre-selection might be useful.
Aren't there any criteria which you could use to limit the choices?

If you really need all entries, you might have to split your records up, i.e. write a routine, that will populate your box with the first 32k and then allow the user to switch to the next 32k. This way you would avoid the integer limit...

MakeItSo

Andreas Galambos
EDP / Technical Support Specialist
Bowne Global Solutions Wuppertal, Germany
(andreas.galambos@bowneglobal.de)
HP:

http://home.arcor.de/andygalambos

 

[llafretaw]

Cheers for your help, just got handled the app this morning and thought that the requirement was to return all the rows. This would have meant some serious rework, as the NewIndex property is used all over the shop.In addition VB would not be my strongest point, as u many have gathered.
thanks