Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Number Display (Office 2000 through 2003)

    We have account numbers that are 15 digits long. When I format them as numbers, they show something like 2.1200025E+12 in tables, forms, etc. If I format them as text, they display correctly (they are stored as text in an Oracle table).

    My problem is that I need to combine the accounts in these tables (with the text account numbers) with accounts of a different type, stored in other tables, where their 10 digit account numbers display as numbers just fine.

    I'm adding the 15 digit accounts into an existing database with the 10 digits, and I don't want to lose the number functionality of sorting correctly, etc.

    Is there a way to display 15 digit numbers in Access?

    Thanks for your ideas.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Number Display (Office 2000 through 2003)

    If you use a Number (Double) data type, set Format to Fixed and Decimal Places to 0, you can enter and display numbers with up to 15 digits.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    151
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Number Display (Office 2000 through 2003)

    Perfect. Thank you so much for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •