Limit of 150 rows in a combobox?

I can't find an answer to this in the newgroup postings, but it seems
an obvious question so I'm probably missing something: I have an
Access 2003 SP3 ADP file. In one form there is a combo box whose
datasource is a SQL Server stored procedure. The stored procedure
returns 3 columns, 200 rows when executed on SQL Server. The combo box
on the form, however, shows just the first 150 rows in the scrolling
region. What do I need to do to have it show all 200 rows?
The "Tools- Options - Edit/Find" "Don't display lists..." is set to
1000,. The .ListCount for the combobox reports 150 on open, which is
consistent, though not correct. It almost seems that there is some
filter between the stored procedure on SQL Server and Access which
imposes this 150 row limit, but I can't imagine what it is or where it
is. Any advice on finding these missing rows would be most
appreciated!

= M =

.

Relevant Pages

  • Re: SQLServer dosnt throw warning message !
    ... SQL Server introduced "deferred Name resolution" with 7.0. ... Tibor Karaszi, SQL Server MVP ... > missing tables, I thought this message is for any kind of object. ... >> I believe it only throws that error for a missing stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)
Loading