converting numeric into alpa

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerald - 03 Aug 2005 11:26 GMT

I have a currency feild which captures amount in standart format ..(4,55.50$)

I want the format to be converted into alpabets when pressed tab and goes in
another field e.g Four Hundred Fifty Five Dollors and 50 cents only

plz help

Thanks

Reply to this Message

Brendan Reynolds - 03 Aug 2005 11:32 GMT

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

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

Signature

Brendan Reynolds (MVP)

>I have a currency feild which captures amount in standart format
>..(4,55.50$)
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Gerald - 07 Aug 2005 11:57 GMT

Hi Brendon,

Thanks for the link

I copied the code in the text field, but when I enter in the field I get a
Compile Error Message, Expected End Sub

Can you help ?

Thanks

> There's code to do this at the following URL ...
>
[quoted text clipped - 10 lines]
> >
> > Thanks

Reply to this Message

Brendan Reynolds - 07 Aug 2005 16:51 GMT

You need to put the code in a standard module. (To create a new standard
module, when the database window is active select Module from the Insert
menu). Then you can use the function just as you would use any of the
built-in functions. For example, to display the text in a text box, you
could set the ControlSource property of the text box to ...

=English([SomeField])

... where 'SomeField' is the name of your currency field.

Make sure the currency field is included in the form's record source, and
that the text box does not have the same name as the field.

Signature

Brendan Reynolds (MVP)

> Hi Brendon,
>
[quoted text clipped - 22 lines]
>> >
>> > Thanks

Reply to this Message

Gerald - 08 Aug 2005 07:11 GMT

Thanks, Brendan. That was helpful

Last but not least, can u help me in below

1. at the end of the alpa for currency it has 'exactly' and I need as 'only'
2. when currency has decimal it shows e.g. five hundred 50/100 not
3. can we make all as ALL CAPITALS
4. ideally it should allow me the select the currency e.g pound , dollor or
else
e.g FIVE HUNDRED DOLLARS AND 50 CENTS

Any help on above will be appreciated

Many thanks

> You need to put the code in a standard module. (To create a new standard
> module, when the database window is active select Module from the Insert
[quoted text clipped - 35 lines]
> >> >
> >> > Thanks

Reply to this Message

Gerald - 09 Aug 2005 05:37 GMT

Hi Brendon,

That works, thanks a lot. all my queries solved except one

for decimal values it still shows 50/100, I am trying on new dbase as did on
rest

if u come across plz do let me know

Thanks a bunch

> There's code to do this at the following URL ...
>
[quoted text clipped - 10 lines]
> >
> > Thanks

Reply to this Message