Number to text

[Guest]

Dear gurus,
I have a number field in a report, i.e. it shows 1550.56.
I have also the following unbound objects in the same report:
- Thousands (must show one)
- Hundreds (must show five)
- Tens (must show five)
- Pounds (must show zero)
- Cents (must show fifty six)
How can I achieve this?
Thank you so much for your help

George

 

[Brendan Reynolds]

There's code to do that at the following URL ...

http://www.mvps.org/access/modules/mdl0001.htm

 

[Guest]

Thanks for your reply,

I am so novice in VBA. How can I use that function to display the text of
amount in my report?

George

Ο χÏήστης "Brendan Reynolds" έγγÏαψε:

 

[Guest]

Thanks a lot Brendad,

I found it: I added an unbound on my report and on the control source I
have used: =english([amount])

Thanks a million!!!
))))))

Ο χÏήστης "George" έγγÏαψε: