Add an option to access

  • Thread starter Thread starter Jone
  • Start date Start date
J

Jone

In access by tables in data type currency there should an option full
currency for i.e. $1,234.56 should be spelled out like this, “One thousand 2
hundred thirty four dollars and fifty six centsâ€

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-a4be-a5b9bf73a440&dg=microsoft.public.access
 
Jone said:
In access by tables in data type currency there should an option full
currency for i.e. $1,234.56 should be spelled out like this, “One thousand 2
hundred thirty four dollars and fifty six cents”
Click to expand...

Convert Currency ($500) into words (Five Hundred Dollars)
http://www.mvps.org/access/modules/mdl0001.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Thanks; but how do I use this cod eand where do I type it that it shouls come
out like that?
 
Jone said:
Thanks; but how do I use this cod eand where do I type it that it shouls come
out like that?
Click to expand...

You will need to put this in the appropriate report section OnPrint
event.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top