Format Question
Hi Guys,
I may not have explained myself properly yesterday so I am re-posting hoping
this time I have explained a little better.
Can someone tell me why?
I have a form called "ResultsForm"
On that form I have a label called "SRWValueCalculated"
In my code I have "Dim TotalCost As Currency" which gets its value using
this bit of code:
"TotalCost = TotalCost + Cost4GoodRecs + Cost4BadRecs + Cost4DOBRecs"
The variables above, Cost4GoodRecs, Cost4BadRecs, Cost4DOBRecs are all
dimensioned as Currency
If I format the label Like so:
ResultsForm.SRWValueCalculated = Format(TotalCost, "###,##0.00")
If the value of TotalCost is 5,241.60 it displays as 5,241.60 which is fine,
but, if the value of TotalCost is 10,483.20 it
displays as 10,483.2 missing the final 0 (zero)
What is wrong?
As always, your help is appreciated.
Best Regards,
Steve.
|