MS Access Listbox results limit

[tranchemontaigne]

Does anyone know a registry hack or other fix that will allow a list box to display more than 200 results?

 

[HarleyQuinn]

A listbox should have no trouble at all displaying more than 200 records.

How are you populating it??

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[agfon]

I have found that if the rowsourcetype of the listbox is set to value list, then there is a limitation on the row source to around 2048 characters.

I haven't found any way around this except to switch out the listbox for a listview control.

 

[formerTexan]

Hi,

Two ideas come to mind.

The first is to programmatically break up the delimited string currently used as a row source and pass it to a table. Then use the table as the list box's rowsoure.

Or instead pass the string to an array and then use a List Call Back function to load the list box.

Where is the value list coming from and does it get altered frequently?

Cheers,
Bill

 

[tranchemontaigne]

The listbox shows a list of contacts to disease report cases. As new cases are added and their contacts are entered the list grows and grows fast. I currently have a query string for the rowsource of the listbox, but only the first 200 individuals are listed.

The query string is used to sort the data in the underlying table into an ascending order by more than one variable.

 

[formerTexan]

Hi,

Where is the repository for the data from case contacts? I also think we may be having some semantic confusion. I am not sure you are using "query string" to refer to a SQL string or the concatenated results of a query. However...

Since your data is dynamic (changing frequently), it is advisable that you retain the data in a table. Then set the list box's rowsourcetype to Table/Query and set the rowsource to a pertinent table, query or SQL string.

Cheers.
Bill