|
SOLVED: Format Property |
Post Reply 
|
| Author | |
ElvisM 
Senior Member 
Joined: 12 October 2006 Location: Venezuela Status: Offline Points: 129 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: SOLVED: Format PropertyPosted: 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 |
|
 |
|
|
6ero
Newbie 
Joined: 19 August 2006 Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
irman_herdiana
Newbie
Joined: 10 August 2007 Status: Offline Points: 6 |
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
|
gaudetm
Senior Member
Joined: 23 September 2006 Location: Canada Status: Offline Points: 134 |
Post Options
Thanks(0)
Quote Reply
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
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options