Check writing

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

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


RAB said:
As in the case of writing a check, we put in the dollar and cents amount.
Click to expand...
Then we would write out the amount seperating the dollars from the cents.
How can this be done in MS access?
 
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
 
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


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