Add an option to access

[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

 

[Tony Toews [MVP]]

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”

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/

 

[Jone]

Thanks; but how do I use this cod eand where do I type it that it shouls come
out like that?

 

[Tony Toews [MVP]]

Thanks; but how do I use this cod eand where do I type it that it shouls come
out like that?

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/

 

[Jone]

Thanks; sorry for those spelling mistakes I wrote it fast

 

[Jone]

But this should ba an option in ms access

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/