Results 1 to 3 of 3

Thread: [RESOLVED] Decimal format

  1. Mar 29th, 2006, 01:56 PM #1
    Zoila
    Zoila is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Location
    AZ
    Posts
    67

    Resolved [RESOLVED] Decimal format

    Quick ?

    assign 2 decimal placement to a label caption read from a recordset value

    I tried using the Data Format field of the Label to set to 2o decimal places.

    What is the Convert Function. I don't recall.

    Thanks
    Silly Me
    Reply With Quote Reply With Quote
  2. Mar 29th, 2006, 01:57 PM #2
    BrailleSchool
    BrailleSchool is offline
    PowerPoster
    Join Date
    Apr 2005
    Location
    Debug.Print
    Posts
    3,885

    Re: Decimal format

    Quote Originally Posted by Zoila
    Quick ?

    assign 2 decimal placement to a label caption read from a recordset value

    I tried using the Data Format field of the Label to set to 2o decimal places.

    What is the Convert Function. I don't recall.

    Thanks
    Silly Me
    formatpercent() assigns 2 decimal places
    Notary Public in and for the State of Iowa. Web site: http://www.ianotary.us

    A+, DCSE, e-Biz+, i-Net+, MCDST, MCP, Network+, Security+, A.A.S (Hons.)
    Visual Basic .NET Video Tutorials | Login Form using backend database (.NET) | Useful site for sending email through .NET | Encrypt/Decrypt data in SQL Server 2005 using SQL statements | Writing Managed Stored Procedures in SQL Server 2005 | FREE .NET Calendar Control | Useful WinForm Controls | Regular Expression (Regex) Library | Backup/Restore SQL Server 2005 Database using code | Verify SQL Server 2005 database backup using SMO | Backup SQL Server 2005 database using SMO | Restore SQL Server 2005 database using SMO | Use FxCop from Microsoft to aid with code optimization
    Reply With Quote Reply With Quote
  3. Mar 29th, 2006, 02:09 PM #3
    Zoila
    Zoila is offline

    Thread Starter
    Lively Member
    Join Date
    Jun 2005
    Location
    AZ
    Posts
    67

    Talking Re: Decimal format

    Used

    Format(Expression,"###,###,##0.00")

    Thanks !!!!

    the Formatpercentage give a % at the end.
    Thanks !!!
    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