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
