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
lblCurrency.caption = Format(243412345.5234, "$0,000.00")
or simply
lbltotal = Format(lbl, "currency")
lbltotal = Format(lbl, "currency")
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
`
lbltotal = Format(val(lblFirst) + val(lblSecond), "currency")
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!
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?
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?
Moderator, my recommended disposition is:
Accept bobbit31's comment(s) as an answer.
DanRollins -- EE database cleanup volunteer
Accept bobbit31's comment(s) as an answer.
DanRollins -- EE database cleanup volunteer