SOLVED: Format Property
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=6460
Printed Date: 10 July 2025 at 11:23am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: SOLVED: Format Property
Posted By: ElvisM
Subject: SOLVED: Format Property
Date Posted: 19 February 2007 at 10:51am
|
Hi, excuseme, but my english is so short.
Question: There is a way to make this with the format property?
 I was using the "$ %s" value for the format property, but it don't show the thounsands separators, and I can't to put 2 digits for the decimal position.
Thanks for your time
------------- Product: Xtreme SuitePro (ActiveX) version 17.2 Platform: Windows 10 64bits Language: Visual Basic 2015 |
Replies:
Posted By: 6ero
Date Posted: 06 April 2007 at 2:19pm
|
You can't do it using the format property  .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. |
Posted By: irman_herdiana
Date Posted: 12 August 2007 at 8:49pm
| but when i use the format currency the cell cannot be edited..its always change into original number. |
Posted By: gaudetm
Date Posted: 14 August 2007 at 9:02am
|
I would like to know what code is need to do the backcolor for one row of two. can you send it here so someone else can also use it?
Thanks
|