PDA

Click to See Complete Forum and Search --> : Set To 2 Decimal Place


alwsid
Mar 13th, 2000, 02:13 PM
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..

VorTechS
Mar 13th, 2000, 04:00 PM
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!