[AccessD] Combo box not displaying 6 numbers

[Rocky Smolin]

I didn't know about that - it was set at 1000.  But when I upped it to
100,000 and then to 200,000 it made no difference.

r

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
David Emerson
Sent: Thursday, March 09, 2017 12:28 PM
To: 'Access Developers discussion and problem solving'; 'Off Topic'
Subject: Re: [AccessD] Combo box not displaying 6 numbers

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


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