Inserting VB in Access report - HELP!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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
 
Back
Top