Microsoft KB Archive/207601

= ACC2000: Combo Boxes Limited to 65536 (64 KB) Rows =

Article ID: 207601

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q207601



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

For a Microsoft Access 97 and earlier version of this article, see 187342.



SYMPTOMS
When you view the list portion of a combo box or a list box that is based on a table, a query, a view, or a stored procedure with more than 65,536 records, you only see the first 65,536 rows.



CAUSE
Microsoft Access limits the number of rows displayed in a combo box or a list box to 65,536 rows.



RESOLUTION
Use a query, a view, or a stored procedure to restrict the number of rows that the combo box or the list box is displaying to no more than 65,536.



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb.  Create a module and type the following line in the Declarations section if it is not already there: Option Explicit   Type the following procedure: Sub FillTable ' Creates a table that contains ' 70,000 records.

Dim db As DAO.Database Dim tbl As DAO.TableDef Dim fld As DAO.Field Dim rs As DAO.Recordset Dim lng As Long

Set db = CurrentDb Set tbl = db.CreateTableDef tbl.Name = "LargeTable" Set fld = tbl.CreateField("Field1", dbLong) tbl.Fields.Append fld db.TableDefs.Append tbl Set rs = tbl.OpenRecordset(dbOpenDynaset) For lng = 1 To 70000 rs.AddNew rs.Fields("Field1") = lng rs.Update Next rs.Close MsgBox "Table Created" End Sub  To run this procedure, type the following line in the Immediate window, and then press ENTER:

FillTable

When the procedure is finished, you receive a message indicating that the table was created. Open a new form in Design view, and add a combo box to the form.</li> Set the RowSource property of the combo box to LargeTable.</li> Open the form in Form view.</li> Type 65536 in the combo box.</li> Click the arrow next to the combo box to view the list. Note that 65536 is the last visible row in the combo box.</li></ol>

Additional query words: missing not all there truncated prb don't display see do

Keywords: kbprb KB207601

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.