[AccessD] Combo box not displaying 6 numbers

[Rocky Smolin]

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