If the report is based on a query, add a column to the query, in the column
name box write: convertedAmount:your vba code that converts it.
Then add that column (convertedAmount) to the report.
I think you can also add the code to the control source of a report field.
hope this helps you,
Kurt Monroe
> I need to insert the code for converting numbers to text for purposes of a
> "paycheck" report. I found the code online but have no idea how VB works in
> access or how to get it where I need it. Can anyone help??