Results 1 to 2 of 2

Thread: Set To 2 Decimal Place

  1. Mar 13th, 2000, 03:13 PM #1
    alwsid
    alwsid is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 1999
    Location
    Malaysia
    Posts
    108

    Post

    Hello There...

    I've build xml database using Access 2000.
    So when I'm open that database using IE5 Browser,
    the field which data type as number(single)have more than
    2 decimal place(Ex:23.12678).
    My problem => How could I format my field to 2 decimal place using vbscript.

    Hope someone can help me..

    Reply With Quote Reply With Quote
  2. Mar 13th, 2000, 05:00 PM #2
    VorTechS
    VorTechS is offline
    Lively Member
    Join Date
    Jan 1999
    Location
    Gloucester, UK
    Posts
    78

    Post

    Providing VB Script has the 'FORMAT' keyword you can do something similar to: -

    lblMyFormLabel = Format(lngMyVeryLongNumber,"0.00")

    There's a lot you can do with Format, just check out your help files!
    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