[AccessD] Combo box not displaying 6 numbers

[Jim Dettman]

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

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

Jim

Sent from my iPhone

> On Mar 9, 2017, at 6:30 PM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> 
> 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.
> 
> R
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
> Dettman
> Sent: Thursday, March 09, 2017 1:45 PM
> To: 'Access Developers discussion and problem solving'; 'Off Topic'
> Subject: Re: [AccessD] Combo box not displaying 6 numbers
> 
> 
> Rocky,
> 
> The limit on a combo's rows is 64K (65535).
> 
> Jim. 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Rocky Smolin
> Sent: Thursday, March 09, 2017 02:45 PM
> To: 'Access Developers discussion and problem solving'; 'Off Topic'
> Subject: [AccessD] Combo box not displaying 6 numbers
> 
> Dear List(s):
> 
> 
> 
> I have a very simply two column combo box based on a query.  First column is
> the PK, second column is a case number.
> 
> The range of case numbers is 1001 through 162956.  The bound column is 1 and
> the column widths are 0";2"
> 
> 
> 
> However the dropped down list only lists up to the last 5 digit case number
> - 99999.  The rest of the numbers which are six digits do not show in the
> dropped down list.
> 
> 
> 
> When I run the query by itself all the records including ones with 6 digit
> case numbers are retrieved.
> 
> 
> 
> If I enter a six digit case number into the combo box it is accepted even
> though it does not auto fill.
> 
> 
> 
> The case number in the table is Long Integer.
> 
> 
> 
> And I am stumped.  Any ideas?
> 
> 
> 
> MTIA
> 
> 
> 
> 
> 
> Rocky Smolin
> 
> Beach Access Software
> 
> 760-683-5777
> 
> <http://www.bchacc.com> www.bchacc.com
> 
> <http://www.e-z-mrp.com> www.e-z-mrp.com
> 
> Skype: rocky.smolin
> 
> 
> 
> 
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com