[AccessD] Combo box not displaying 6 numbers

[Jim Dettman]

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