Inserting VB in Access report - HELP!

S

Schoolie

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??
 
K

Kurt Monroe

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
 
Top