Link to home
Start Free TrialLog in
Avatar of 4Merlin4
4Merlin4

asked on

VB Currency

Wondering if anyone can help I have a lbl that generates a total from 2 other lbls, heres the problem I have a cmdpost that post the total into a total lbl but that lbl has to display the number in a currency form like $XXX.XX. Its the same number in the first total lbl but in the other total lbl it has to be in currency
Avatar of bobbit31
bobbit31
Flag of United States of America image

lblCurrency.caption = Format(243412345.5234, "$0,000.00")
Avatar of DocM
DocM

or simply
lbltotal = Format(lbl, "currency")
Avatar of 4Merlin4

ASKER

that helps but the lbltotal has to keep a running total the addition just doesn't happen once it can happen multiple times
ASKER CERTIFIED SOLUTION
Avatar of bobbit31
bobbit31
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
`
lbltotal = Format(val(lblFirst) + val(lblSecond), "currency")
lblSum.caption = Format(val(format(lblCur1.catpiton)) + val(format(lblCur2.caption)), "Currency")

Format will get rid of "$" sign and convert to a number


Good Luck!
4Merlin4:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
Avatar of DanRollins
Moderator, my recommended disposition is:

    Accept bobbit31's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer