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

currency to text

P: n/a
I am a newbie to Access. I have been using Paradox for Windows for several
years. I imported my data successfully to Access2000.
I want to code a form that will convert currency to text. For example
field1 value = -201.50. I want to arrive at field2 and convert the negative
201.50 in filed1 to
two hundred one and 50/100***** in field2. How do I program Access to do
this?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
There is some code for that here:
http://www.mvps.org/access/modules/mdl0001.htm

On Sun, 04 Jan 2004 21:25:36 GMT, "Michael Israel"
<mb***@spamlessoptonline.net> wrote:
I am a newbie to Access. I have been using Paradox for Windows for several
years. I imported my data successfully to Access2000.
I want to code a form that will convert currency to text. For example
field1 value = -201.50. I want to arrive at field2 and convert the negative
201.50 in filed1 to
two hundred one and 50/100***** in field2. How do I program Access to do
this?


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.