Check Writing Function - Numbers to Text Conversion

  • Thread starter Thread starter Brig
  • Start date Start date
B

Brig

Hello,

For Access 2000, is there a code I can look at for reference on how to
transfer numbers to text like in a check writing software?

For example: $1,500.00 converts to ONE THOUSAND FIVE HUNDRED DOLLARS & 00
CENTS.

Also, where can I get a font for the routing and bank account number?

Thank you very much for your help in advance.
 
Also, where can I get a font for the routing and bank account number?

Are you planning to print checks from scratch on blank paper?

Nornally (or always?) checks are printed on pre-printed forms, where you only
fill in the stuff like the amounts and dates etc.

And, I think the routing and bank account numbers are printed with a special
magnetic ink, which enables the sorting process. Can you do that?

And I think banks may require checks with special anti-forgey features.


But what do I know? Seriously, I don't know much about this, but those are
questions that came to my mind when I read your message.

Rick

PS, there's probably some code somewhere to translate numbers to text like you
want, but I don't know where. Have you tried any searches with google?
 
Seems like whenever I post a message I have to quickly follow up with a
correction....

I found the font you want on my PC. It's named MICR.TTF. I don't know where
it came from, though. It probably came with either my operating system -
Windows XP.. or with MS Office 2003.

If you do a search on that name on your PC, you might find it.

Rick
 
Thank you very much for your help.

We will print the checks on a pre-printed form dual-perforated paper.

We will use a MICR toner to print the checks, and yes, we can do that.

Yes, the check stock has anti-forgery feature.

Brig
 
RSGinCA said:
Are you planning to print checks from scratch on blank paper?

Nornally (or always?) checks are printed on pre-printed forms, where you only
fill in the stuff like the amounts and dates etc.

And, I think the routing and bank account numbers are printed with a special
magnetic ink, which enables the sorting process. Can you do that?

And I think banks may require checks with special anti-forgey features.


But what do I know? Seriously, I don't know much about this, but those are
questions that came to my mind when I read your message.

Rick

PS, there's probably some code somewhere to translate numbers to text like you
want, but I don't know where. Have you tried any searches with google?

Here's One:
http://vbnet.mvps.org/code/helpers/numbertotext.htm
 
And for the second;


Because the specifications for MICR characters are for the
printed characters (not the on-screen, or bitmapped,
dimensions of the MICR font) each MICR laser printer must
use a custom MICR font tailored to the characteristics of
that particular printer. There is not one universal MICR
font set that will work in every MICR laser printer. A
MICR font is optimized for a specific printer only after
months of stringent research and testing.


http://www.burtonmicr.com/fonts.html

It's amazing what Google will come up with.


Chris
 
Back
Top