Custom List Box functions - how many rows are too much?

[simon_marklar]

Hi all,

I've been making some custom functions for listboxes so they can display data from multiple tables and records on one row, and its really simplified some forms for me. I was about to do another one until i realised that this listbox could potentially have over 2500 rows (it wont ever have that much, due to business rules on which customers can be shown). I've done a quick search through the docs + online and cant find anything that would suggest a custom function for this many records is a no-no, but before i go ahead and do it, I thought i'd see if anyone here has used custom functions to display data in a list box and run into limitations on the amount of rows?

thanks you
%simon

 

[pono1]

Simon,

I think the row capacity for a listbox is roughly 65,000...

Regards,
Tim

 

[raskew]

Hi -

Take a look at Allen Browne's site http://allenbrowne.com/ser-32.html under "Combo Boxes with Tens of Thousands of Records". You might be able to adapt his technique in your application.

Bob