Harry Batt
asked on
VB Syntax Format Currency
Hello Experts,
I have a syntax question regarding the following line of code. What I want to do is format the "TotalGifts" field referenced on a subform as currency. Could someone help me rewrite it so that it works? The result should be Total Gifts: $(amount)
Thanks!
"Total Gifts: " & Forms![Main]![SubForm1].Fo rm!subfrmG iftTotals. Form.[Tota lGifts]
I have a syntax question regarding the following line of code. What I want to do is format the "TotalGifts" field referenced on a subform as currency. Could someone help me rewrite it so that it works? The result should be Total Gifts: $(amount)
Thanks!
"Total Gifts: " & Forms![Main]![SubForm1].Fo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi pratima
I did try that but don't want the "$" to appear if not necessary. In another instance I used this format and I am looking for something similar.
"Payment Amount: " & Format(CCur(Me.PaymentAmou nt), "Currency")
Thanks
I did try that but don't want the "$" to appear if not necessary. In another instance I used this format and I am looking for something similar.
"Payment Amount: " & Format(CCur(Me.PaymentAmou
Thanks
ASKER
Hi DatabaseMX,
You nailed it.
Thanks for your help,
Harry
You nailed it.
Thanks for your help,
Harry
You are welcome ...
mx
mx
"Total Gifts: " & Forms![Main]![SubForm1].Fo
I think like
Total Gifts: amount
you want to change it ot
Total Gifts: $(amount)
then tri this
"Total Gifts: $(" & Forms![Main]![SubForm1].Fo