98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Currency symbols
Currency symbols
Resolved · Low Priority · Version 2003
Tue 18 Aug 2009, 15:30Delegate Adele said...
Adele has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Currency symbols
If you have selected the format on a variable as currency - how do you have a $ symbol displaying rather than £?
Thu 20 Aug 2009, 16:11Trainer Stephen said...
RE: Currency symbols
Hi Adele
Thank you for your question
You need to set the text box's property setting when it opens
The following line of code will display the dollar symbol.
Me.txtTotal.Format = "$##,#0.00"To replace the dollar symbol with for example the yen symbol replace the dollar symbol with the relevant ascii code
Regards
Stephen
Thu 27 Aug 2009: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |
