SpellNumber macro in Access report

[jrh]

I use a macro called SpellNumber in Excel that takes a
numeric number from a specified cell and converts it to
text. I would like to use that same macro in an Access
report but I'm not smart enough about Access to figure out
how to do it. Any ideas?

 

[Steve Schapel]

Jrh,

For a start, macros in Excel and macros in Access are totally
different creatures/concepts.

In Access, the type of thing you are talking about can not be done
with a macro. You need to apply a user-defined function to the field
inthe query that the report is based on. The function needs to be
written in a VBA module. An example of such a function, applied to
currency amounts, can be found at
http://www.mvps.org/access/modules/mdl0001.htm

- Steve Schapel, Microsoft Access MVP