Check writing

[Guest]

As in the case of writing a check, we put in the dollar and cents amount. Then we would write out the amount seperating the dollars from the cents. How can this be done in MS access?

 

[Cheryl Fischer]

There is a very nice function at the Access Web that will do that for you.

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


hth,
--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

As in the case of writing a check, we put in the dollar and cents amount.

Then we would write out the amount seperating the dollars from the cents.
How can this be done in MS access?

 

[Guest]

I thank you very much for the help. I am new to MS access and I have never done and VBA. Where would I put this code. Any help in this regard would be appreciated

Thanks Again

 

[Cheryl Fischer]

It is pretty simple:

1. Copy all of the code found at that link into a public Module. Save and
close the module.

2. On your report or form, create an unbound TextBox. In the ControlSource
for that TextBox, insert the following:

=English(MyAmount)

Substitute the name of your Field or Control for "MyAmount".

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I thank you very much for the help. I am new to MS access and I have

never done and VBA. Where would I put this code. Any help in this regard
would be appreciated.