473,395 Members | 1,677 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Convert Currency to Text

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
1 7023
ADezii
8,834 Expert 8TB
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

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

Similar topics

2
by: KB | last post by:
Hi guys, In my DataGrid I have a column that displays decimal values as currency ( I set the Data Formatting expression of that column to {0:C}). So the actual string displayed in the grid looks...
2
by: UJ | last post by:
I have need to convert a text string (with formatting) to an image. This is so that I can resize the image to different sizes and the formatting stays exactly the same regardless of the size. I...
1
by: Husam | last post by:
Hi EveryBody: I have this code which convert RTF Text to HTML ? but I think it is written by vb.classic, I want some body help my in writting this code by Vb.Net ? but if it is already writen by...
1
by: Beckster6701 | last post by:
I have a MSAccess database that is linked to a SQL server. I cannot change the SQL server datatype as I am not the only one that uses the database. I'm trying to convert the text field to a valid...
11
by: asenthil | last post by:
Hai to all... this is senthil.... i want to convert a text data into a xml data.... is there any source codes available in the net? or is there any methods, classes available for this type...
7
by: chelle2100 | last post by:
hi... i need to write a converter to convert the text file to a binary file with the following file format... CharacterCount:Unsigned Char(This stores the number of characters that is in the file)...
2
vivek kushwaha
by: vivek kushwaha | last post by:
Hi guys, I need codes to convert Currency into Words. e.g. 120,500 into "One Lac. Five hundred only." in asp.net with vb.net 1.1. Please if anybody know about it. Reply me. Vivek.
6
by: cmdolcet69 | last post by:
Is there a class or anything else that i can use to convert English text to Spanish text in my vb.net programming application?
2
by: RV311 | last post by:
Hello All, How can we convert the text data present in XML to binary data?I have come across links that shows how to do the same using C#.It would be of great help if I get to know about...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.