As I mention below, I was able to store numbers up to 28 digits in tables

using the decimal approach. However, when I tried to use numeric digits

that were 20 long in a combo box it displayed in scientific notation. Do

you think this means I'm pretty much restricted to using the alphanumeric

approach in my app for these long numbers?

As a related question, I noticed that even 10 digit numbers displayed with

.00 at the end in the same combo box, even though I set the combo decimal

places to zero.

Your thoughts will be appreciated.

Bill

Quote:

> Thanks Brian and Marsh. I tried the decimal approach and found that I

could

> use a number up to 28 digits. It's good to know that I also have the text

> option that Marsh offered.

> Bill

> > I have an application involving several hundred bank accounts whose

> account

> > numbers range from 5 digits to 20 digits in length. For sorting

purposes

> I

> > would like to define the account number as a numeric field, but Access

> 2000

> > apparently will only handle 10 numeric characters in long integer, and

> about

> > 15 in double before displaying the number in scientific notation.

> > If defined as a text field there would be sorting problems. For example

> > account number 19501 would sort after account 175567890 since they would

> be

> > left justified.

> > Is there any optional way of achieving the desired sort results with

> either

> > numeric or text fields?

> > Bill