Report Control - Format the item in Column (Fix 2 decimal point)

Print Page | Close Window

Format the item in Column (Fix 2 decimal point)

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=4624
Printed Date: 05 July 2025 at 1:52am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Format the item in Column (Fix 2 decimal point)

Posted By: cybeh
Subject: Format the item in Column (Fix 2 decimal point)
Date Posted: 20 July 2006 at 4:33am

Hi,

May I know how can I fix the format of an column value? like
2.00 <- 2 decimal point?

Please advice.

Replies:

Posted By: 6ero
Date Posted: 06 April 2007 at 2:22pm

I use the "value" property to store the number and the "caption" property to display my own formatted string of that number.

Example:

Set Item = Record.AddItem(total)
Item.caption= FormatCurrency(total, 2)

This will sort fine also.

I hope this helps anybody trying to do the same thing.