Printing Checks

[Jeremy Kropf]

I am wanting to design a report for my access database
that will print checks. The problem I am having is that I
want to spell out the ammount in words like you normally
do on a check. I know in Microsoft Word you can use the
DollarText format option, but I am not having success in
Access.

Can someone please help me?

 

[Cheryl Fischer]

There is code to convert currency numeric values into words at:

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

hth,

 

[Duane Hookom]

Check the code at http://www.mvps.org/access/modules/mdl0001.htm

 

[Harsh]

Were you able to print the fields at correct positions on
the check? I am having trouble maintaining spacing from
check to check. How did you do it?

 

[Evi]

For the first question you would need to write a horribly long function to
do the job...but luckily Joe Foster has already done this at

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

For the second question, make sure that your controls and sections are set
to Can't Shrink

Evi