Numbers to Letters?

[cos]

How can i make a seporate column in the table to tell me what sum i entered in the other column in writing?
So that for instance in one field i will enter: 122
and automatically in another field i will have: one hundred and twenty two

i read that i could create a moduel, but how and where, i have no idea.

any ideas at all?

 

[pbaldy]

You'd put a function like this:

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

in a standard module and call it from anywhere.

 

[cos]

Okay, so where do i put this code (function) so that i can use it?

 

[pbaldy]

Like I said, a standard module. Hit Alt-F11 hike in Access to bring up the VBA editor, then Insert/Module.

 

[cos]

quick question: how do i then activate or asign that moduel to my wanted column in my table, so that theresults are projected and recorded in there?

 

[Beetle]

You wouldn't use the function in a table. You would call it in a calculated query field or in a calculated control on a form or report. Calculated or derived data like this should not be stored in your table. To call it do one of the following (examples);

In a query field:

NumToWords: English([YourNumberField])

In a form or report Control (like a text box - this goes in the Control Source property):

=English([YourNumberField])