Listbox Maximum Rows

D

Dale

I am trying to fill an Access 2000 list box with more
than 10,000 rows from a sql 2000 table, but it only fills
10,000.

I have filled over 65,000 rows from an Access table, but
sql won't fill more than 10,000.

Is there anything I can do?
 
S

Sylvain Lafontaine

Yeah, check for the parameter "Default max records" under the Advanced tab
in the options dialog window.

S. L.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeating a row other than the 1st row as the header row in a table from next page 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Creating Labels Over 3-Up Image 2
Weigh tasks 0
Displaying a range based on a cell's contents 3
Dealing with a Pivot Table (when I don't want to) 0
Publisher is filling blank lines with data 2

Top