SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict djh's Avatar
    Join Date
    Apr 2000
    Location
    Long Beach, CA
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey all.

    I'm displaying a number field in my Access database in currency format using the following:

    FormatCurrency(blahblah)

    But it displays with two decimal points that I don't want. How do I modify this?? Any easy way? Has to be an attribute, right?

  2. #2
    Your Lord and Master, Foamy gold trophy Hierophant's Avatar
    Join Date
    Aug 1999
    Location
    Lancaster, Ca. USA
    Posts
    12,305
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    FormatCurrency(Expression, NumDigitsAfterDecimal, IncludeLeadingDigit, UseParensForNegativeNumbers, GroupDigit)

    The FormatCurrency function return a formatted currency value for the numeric expression.

    There is one mandatory argument.

    Expression

    The Expression argument is the number to be converted to a currency format.


    So:
    <% =FormatCurrency(12345, 2) %>

    Would be
    $12345.00

    For a complete VBScript reference visit Devguru.com. You can view it online or download it to your local PC.
    Wayne Luke
    ------------



Bookmarks

Posting Permissions

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