2. ASPRunnerPro General questions
  3. Displaying number fields
This topic is locked

Displaying number fields

 		4/12/2007 06:08:20
ASPRunnerPro General questions
G
 grinningdog author

Hi
I've got some number fields in my Access db that are set with no decimal places. If I calculate those fields using an event it puts the correct value in the field (ie. 23,24,25 etc) but the display in ASPRunner gives me two decimal places (ie 25.00) In the Visual Editor for the list page (which is all I've got on this table view) I can set the field as a number but that seems to default to 2 decimal places, with no option to change.
Is that correct and is there a way to force no decimal places?
Bob
J
 		Jane 4/12/2007

Bob,
to diplay numeric field without decimal places select nothing on the "View as" settings dialog on the Visual Editor tab.
We'll add number formatting in the next ASPRunnerPro version.
G
 		grinningdog author 4/12/2007

Thank you Jane, that works great
R
 		rgke 4/19/2007

Do you have an expected release date for that? I am struggling a bit with this because I need commas between the thousands, but no decimal places
Sergey Kornilov admin 4/19/2007

Rgke,
use "View as" type "Custom" and the following code:

strValue = FormatNumber(strValue,0)
R
 		rgke 4/20/2007

Oh great. I didn't release it was than simple! Thanks