converting numeric into alpa

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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.
 
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


Brendan Reynolds said:
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.

--
Brendan Reynolds (MVP)


Gerald said:
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
Click to expand...
Click to expand...
 
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
 
Back
Top