[AccessD] Combo box not displaying 6 numbers

[Rocky Smolin]

I designed it that way before I realized the number of records there would
be. I may not be necessary to have it there. But I am unsure how the user
will be using the data.  

The data is imported from other sources - they are calls into a call center.
The combo box contains a case number. If the call refers to a case that's
not there 

Normally, it should not necessary to do any editing as the calls are
imported and summarized in a report. But if a call references a case number
that's not in the system, the user would enter that case data manually on
the case form and then select that case from the combo box on the calls
form.

But your question makes me rethink this,  I'll have to ask the user how
they'd prefer it.

Thanks

R

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Susan Harkins
Sent: Friday, March 10, 2017 3:45 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo box not displaying 6 numbers

Rocky... I can't help but ask, why are you using combo? Is it really
necessary to present this list in this way? 

Susan H. 


Yes, that would be the work around.   Allen shows that here:

http://allenbrowne.com/ser-32.html

> Well that sucks :/ But probably explains it.  The last number is row
> 65912 which is close enough.
> 
> I once had this situation and I had to write a routine with every key 
> press of the combo box to requery based on what had already been 
> entered.  That was back in Access 97.
> 
> Hope I don't have to do it on this one.  It was a PITA.
> 
> The limit on a combo's rows is 64K (65535).
> 


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com