[AccessD] Combo box not displaying 6 numbers

[Rocky Smolin]

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