Formatting Currency

[denileigh]

I am trying to make a form to enter checks into a database. How do I put a control box on the form so that I can key the amount into the appopriate field such as $9.99 and have it display something like

nine dollars & 99/100********************* ?

Thanks for any help!

Dianne

 

[Mile-O]

This should be a start.

 

[denileigh]

Thanks!

So do I create an unbound text box that = the debit field and then put that in the after update function?