Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Listbox not showing all records

Status
Not open for further replies.

bigkeith

IS-IT--Management
Jul 27, 2001
36
GB
Hello everyone,
I have a listbox on a form that should show all 175 records (and growing) from a table. When I load the form the listbox hardly ever shows all of the records, eg- it usually shows between 40 and 50 records. If I close the form and re-open it, I get varying numbers of records listed. I've tried adding .requery on the load event of the form, but this doesn't work.

Any ideas?

Keith
 
My idea would be for you to reconsider using the ListBox. There is a limit to the number of characters that it can display; somewhere around 2000. I ran into this limit a few years ago.

-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top