Codejock Developer Community : SOLVED: Format Property http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 20:12:42 +0000 Tue, 14 Aug 2007 09:02:47 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=6460 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[SOLVED: Format Property : I would like to know what code...]]> http://forum.codejock.com/forum_posts.asp?TID=6460&PID=25090&title=solved-format-property#25090 Author: gaudetm
Subject: 6460
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
]]> Tue, 14 Aug 2007 09:02:47 +0000 http://forum.codejock.com/forum_posts.asp?TID=6460&PID=25090&title=solved-format-property#25090 <![CDATA[SOLVED: Format Property : but when i use the format currency...]]> http://forum.codejock.com/forum_posts.asp?TID=6460&PID=25048&title=solved-format-property#25048 Author: irman_herdiana
Subject: 6460
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.]]> Sun, 12 Aug 2007 20:49:41 +0000 http://forum.codejock.com/forum_posts.asp?TID=6460&PID=25048&title=solved-format-property#25048 <![CDATA[SOLVED: Format Property : You can&#039;t do it using the...]]> http://forum.codejock.com/forum_posts.asp?TID=6460&PID=21741&title=solved-format-property#21741 Author: 6ero
Subject: 6460
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.
]]> Fri, 06 Apr 2007 14:19:45 +0000 http://forum.codejock.com/forum_posts.asp?TID=6460&PID=21741&title=solved-format-property#21741 <![CDATA[SOLVED: Format Property : Hi, excuseme, but my english is...]]> http://forum.codejock.com/forum_posts.asp?TID=6460&PID=20543&title=solved-format-property#20543 Author: ElvisM
Subject: 6460
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
 
 
]]> Mon, 19 Feb 2007 10:51:28 +0000 http://forum.codejock.com/forum_posts.asp?TID=6460&PID=20543&title=solved-format-property#20543