Combobox Issue

  • Thread starter Thread starter JCCDevel
  • Start date Start date
J

JCCDevel

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)
 
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)










- Show quoted text -
Click to expand...

Sylvain,

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

JCC
 
Back
Top