|
Format the item in Column (Fix 2 decimal point) |
Post Reply 
|
| Author | |
cybeh 
Groupie 
Joined: 27 December 2005 Location: Malaysia Status: Offline Points: 76 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Format the item in Column (Fix 2 decimal point)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. |
|
 |
|
|
6ero
Newbie 
Joined: 19 August 2006 Status: Offline Points: 2 |
Post Options
Thanks(0)
Quote Reply
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. |
|
|
|
|
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