By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,967 Members | 1,267 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,967 IT Pros & Developers. It's quick & easy.

Convert Currency to Text

P: 10
I would like to create a module in Access 2010 to convert currency to display a text string as follows:

Convert 543.27 to display Five Hundred Forty-Three and 27/100

Thanks to anyone willing to assist in this matter
Nov 3 '11 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,679
The answer is in this Insight Link:
http://bytes.com/topic/access/insigh...-numbers-words
To Use This Function:
Expand|Select|Wrap|Line Numbers
  1. Dim strResult as String
  2.  
  3. strResult = StrConv(SayNo(543.27),vbProperCase)
  4.  
  5. Msgbox/Debug.Print strResult
  6.  
  7. 'Results
  8. Five Hundred Forty-three And 27/100
  9.  
Nov 4 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.