Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page