Printing Numbers as Words

  • Thread starter Thread starter ANDREW
  • Start date Start date
A

ANDREW

How do I display a number field as words?

example:
field name: netcheck
datatype: number/single
data: 252.32

Report Display Needed: Two Hundred Fifty-two dollars and 32
Cents.

Even if I could just get the whole numbers in front of the
decimal, that would be a victory.

Currently looking at setting up complex case statement.
 
ANDREW said:
How do I display a number field as words?

example:
field name: netcheck
datatype: number/single
data: 252.32

Report Display Needed: Two Hundred Fifty-two dollars and 32
Cents.

Even if I could just get the whole numbers in front of the
decimal, that would be a victory.

Currently looking at setting up complex case statement.
Click to expand...


There's a function to do that on The Access Web
http://www.mvps.org/access/modules/mdl0001.htm

Add www.mvps.org/access/ to the top of your Access
Favorites. It can answer many questions without waiting for
a newsgroup response.
 
Back
Top