Format Question

[Always Learning]

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.

 

[Bernie Deitrick]

Steve,

It sounds like the label isn't wide enough to show that long of a number. Labels will simply
truncate long strings.

HTH,
Bernie
MS Excel MVP

 

[Bob Phillips]

The reason that you probably got no reply is because, like me, they cannot
replicate this behaviour. I see 10,4383.20 as expected.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Always Learning]

Hi Bob,
Thanks for the reply.

I hope you do not see 10,4383.20 (4 digits after the comma ?)

I know what you mean though, it's hard when someone else does exactly the
same and all is as it should be.
I have got around this by using text boxes instead of labels and all looks
good now.

Thanks for your help & time guys. It's appreciated.

Best Regards,

Steve Wilson.

 

[Bob Phillips]

No it was a typo, only 3 digits.

Did you not see Bernie's answer, I was able to replicate the problem by
narrowing the label width. So I could show 5,241.60, but also only show
10,483.2. Solution was to just make it wider.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)