[AccessD] Combo box not displaying 6 numbers

[David Emerson]

Hi Rocky,

Have you checked Options ... Current database ... Don't display lists where
more than this number of records read?

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Rocky Smolin
Sent: Friday, 10 March 2017 8:45 a.m.
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