Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Convert number

Discussion in 'Information Technology' started by Siew-Ming, Jul 28, 2006.

Tags:
  1. Siew-Ming

    Siew-Ming
    Expand Collapse
    Guest

    Hi,

    Try to format a number field to display in a phone format (999)999-9999 on
    report.

    =format([field1],"(000)000-0000")

    I got #error

    =format(CSTR([field1],"(000)000-0000")

    I got error 0

    What am I missing? Any insights will be greatly appreciated.

    Thanks,
    Siew-Ming
     
  2. Loading...

    Similar Threads Forum Date
    Sikhconvert Joins Sikh Philosophy Network! New SPN'ers Aug 28, 2016
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Islam Ishna Has Converted To Islam Interfaith Dialogues Apr 1, 2016
    A Christian Missionary tried to convert me. Blogs Oct 22, 2015
    "Convert's Corner" - Ideas for Retitle? Convert's Corner Oct 21, 2015

  3. lgalumbres@gmail.com

    lgalumbres@gmail.com
    Expand Collapse
    Guest

    Hi,

    For the text box properties that you have the phone displayed on the
    report. Try the following:

    Under Data tab:
    Control Source ........: [Field1]

    Under Format tab:
    Format........: (000) 000-0000

    Cheers!
    -Lem

    Siew-Ming wrote:
    > Hi,
    >
    > Try to format a number field to display in a phone format (999)999-9999 on
    > report.
    >
    > =format([field1],"(000)000-0000")
    >
    > I got #error
    >
    > =format(CSTR([field1],"(000)000-0000")
    >
    > I got error 0
    >
    > What am I missing? Any insights will be greatly appreciated.
    >
    > Thanks,
    > Siew-Ming
     
  4. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 20 Jul 2006 12:06:01 -0700, Siew-Ming
    <SiewMing@discussions.microsoft.com> wrote:

    >
    >Hi,
    >
    >Try to format a number field to display in a phone format (999)999-9999 on
    >report.


    A phone number should be stored in a Text field. You'll never be doing
    arithmatic with it after all! Number... Long Integer fields are
    limited to values under 2147483647 so if you ever need to use
    international dialing codes, you'll be in trouble!

    >=format([field1],"(000)000-0000")


    Just set the Input Mask property of the field to

    (000)000-0000

    or set the Format property of the form/report control to the same.

    John W. Vinson[MVP]
     

Share This Page