Hi,

We have a MS Access Data Project that is running on Access 2003 with
SP3. We are having an issue with a combobox that displays items
returned from a SQL Server stored procedure. The stored procedure
returns 30567 records, but only the first 30,000 are populated in the
box. Is there a limit to this control? Is it a setting somewhere in
the project?

I know you will all say that 30,000+ records in a combobox seems
crazy, but the users use "type-ahead" to get the item they are looking
for and it is a legacy application that we don't want to rewrite right
now.

Thanks on advance for your help.

JCC

Not sure but: Options | Advanced | Client-server settings: Default max
records

Increase this value from 30000 to 40000.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain aei ca (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


"JCCDevel" <(E-Mail Removed)> wrote in message
news:24babc96-675d-4592-9fca-(E-Mail Removed)...
> Hi,
>
> We have a MS Access Data Project that is running on Access 2003 with
> SP3. We are having an issue with a combobox that displays items
> returned from a SQL Server stored procedure. The stored procedure
> returns 30567 records, but only the first 30,000 are populated in the
> box. Is there a limit to this control? Is it a setting somewhere in
> the project?
>
> I know you will all say that 30,000+ records in a combobox seems
> crazy, but the users use "type-ahead" to get the item they are looking
> for and it is a legacy application that we don't want to rewrite right
> now.
>
> Thanks on advance for your help.
>
> JCC

On Feb 4, 3:28*pm, "Sylvain Lafontaine"
<sylvainlafontaine2...@yahoo.ca> wrote:
> Not sure but: Options | Advanced | Client-server settings: Default max
> records
>
> Increase this value from 30000 to 40000.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Windows Live Platform
> Email: sylvain aei ca (fill the blanks, no spam please)
> Independent consultant and remote programming for Access and SQL-Server
> (French)
>
> "JCCDevel" <JCCMo...@gmail.com> wrote in message
>
> news:24babc96-675d-4592-9fca-(E-Mail Removed)...
>
>
>
> > Hi,
>
> > We have a MS Access Data Project that is running on Access 2003 with
> > SP3. *We are having an issue with a combobox that displays items
> > returned from a SQL Server stored procedure. *The stored procedure
> > returns 30567 records, but only the first 30,000 are populated in the
> > box. *Is there a limit to this control? *Is it a setting somewhere in
> > the project?
>
> > I know you will all say that 30,000+ records in a combobox seems
> > crazy, but the users use "type-ahead" to get the item they are looking
> > for and it is a legacy application that we don't want to rewrite right
> > now.
>
> > Thanks on advance for your help.
>
> > JCC- Hide quoted text -
>
> - Show quoted text -

Sylvain,

That did the trick! Thanks so much for your help!

JCC