Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Currency symbols
|
|
|
The UK's most regular 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. |
Currency symbols
Resolved · Low Priority · Version 2003
Reply 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 £?
For upcoming training course dates see: Pricing & availability
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.
|