Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Christchurch
    Posts
    111
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Long string of numbers (2003)

    Hi, I need to add a field that will contain a very long string of numbers, it will be variable but something like 15 or 20 digits long. My attempts have been to add a field to a table as number data type, the field size would have to be single or double to cater for such a long number. However the format displayed always comes out in exponential format ie 7.12345678+E15. I definitely want strictly the long number, as typed in, to be displayed. It would appear that my only option is to have the data type as text - is that correct? Or am I missing a format option somewhere, perhaps on the form that will display the data?

    Cheers, Roger

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

    Re: Long string of numbers (2003)

    If you need 20 digits, you should use a text field; none of the available numeric data types allow that many digits for whole numbers.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Christchurch
    Posts
    111
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Long string of numbers (2003)

    Thank you <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Roger

Posting Permissions

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