Print Page | Close Window

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 8:25am
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



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net