Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Location
    Northwest England
    Posts
    2

    Unanswered: Numeric Field number of digits

    Hi Everyone,

    I have a numeric field in a form that currently allows an eleven digit number. Any number larger than 11 digits is truncated. I have removed the picture and formatted it as a General number. How can I increase the number of digits allowed?

    For info the specific number is 277525910102 so you can see it does not exceed the floating point range.

    Thanks

    Shaun

  2. #2
    Join Date
    Dec 2007
    Posts
    366
    are you asking how to make the space wider on the form? be sure to make it one bigger than what you need, to allow for the minus sign (that's how the display theory works)
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

  3. #3
    Join Date
    Jan 2012
    Location
    Northwest England
    Posts
    2

    Numeric Field Number of digits

    Hi Steve,

    Your prompt reply spurred me on to do some further investigation. I have now found the answer. The format (picture) of the number is read from a configuration table when the form is loaded and thus caused the issue
    the picture as read from the database is:

    [#[#[#[#[#[#[#[#[#[#[#]]]]]]]]]]]]]]][.#[#]]

    I changed it to:

    [#[#[#[#[#[#[#[#[#[#[#[#[#[#[#]]]]]]]]]]]]]]][.#[#]]

    and everything worked.

    Many thanks for your help

    regards

    Shaun

  4. #4
    Join Date
    Dec 2007
    Posts
    366
    great.. thanks for the follow-up!
    --
    Steven Green - Myrtle Beach, South Carolina USA

    http://www.OasisTradingPost.com

    Oasis Trading Post
    - Collectibles and Memorabilia
    - Vintage Lego Sets and Supplies
    - and Paradox Support, too

Posting Permissions

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