Results 1 to 3 of 3

Thread: [RESOLVED] Formatting Number of decimal places in a formula

  1. Jun 5th, 2006, 10:07 AM #1
    bmahler
    bmahler is offline

    Thread Starter
    Frenzied Member bmahler's Avatar
    Join Date
    Oct 2005
    Location
    Somewhere just west of the Atlantic
    Posts
    1,568

    Resolved [RESOLVED] Formatting Number of decimal places in a formula

    Hi, I have a formula that contains a numerical field. I need to have this in a formula and can not just place the field and i was wondering if there was a way to set the number of decimal places to be displayed in the formula. I know if i just put it on the form I can format it, however is there a way to do this with like a Format() or something. Any help would be appreciated.
    Boooya
    • Visual Studio 2008 Professional
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • Don't forget to rate helpful posts!
    • If you're question was answered please mark your thread [Resolved]


    Code Contributions:
    PHP
    PHP Image Gallery v1.0 • PHP Image Gallery v2.0
    VB 2005
    Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer

    Useful Links: (more to come)
    MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds
    Reply With Quote Reply With Quote
  2. Jun 5th, 2006, 12:14 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Formatting Number of decimal places in a formula

    The formula could return a string with the ToText function

    ToText(Numeric Field, "#,###.##")
    Reply With Quote Reply With Quote
  3. Jun 5th, 2006, 01:07 PM #3
    bmahler
    bmahler is offline

    Thread Starter
    Frenzied Member bmahler's Avatar
    Join Date
    Oct 2005
    Location
    Somewhere just west of the Atlantic
    Posts
    1,568

    Re: Formatting Number of decimal places in a formula

    Thank you, I actually got it to work with

    cStr(Field,4)
    Boooya
    • Visual Studio 2008 Professional
    • Don't forget to use [CODE]your code here[/CODE] when posting code
    • Don't forget to rate helpful posts!
    • If you're question was answered please mark your thread [Resolved]


    Code Contributions:
    PHP
    PHP Image Gallery v1.0 • PHP Image Gallery v2.0
    VB 2005
    Find Computers on a network • Simple License Encryption • SQL Server Database Access dll • Use Reflection to Return Crystal ReportDocument • Silently Print PDF • Generic Xml Serailizer

    Useful Links: (more to come)
    MSDN (The first and foremost) • MSDN Design Guidelines • API Reference • Inno Setup Compiler • Inno Setup Preprocessor • ISTool - Fairly easy to use GUI for creating inno setup projects • Connection Strings • NAnt -Automated Builds • Cruise Control .NET - Frontend for automated builds
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width