how to i run a macro that alters a record in a report.

[thydzik]

how to run a macro that alters a record value in a report.

I think this is a pretty straight forward question.

I have a report with a textbox with control source 'FirstName'. and an example macro in a module like this

Public Function test(v As Variant) As Variant
test = v + "test"
End Function

how do I modify the control source so that it returns test(FirstName) for all values.

thanks

 

[thydzik]

Okay. i wil answer this one myself. don't know why it wasn't working yesterday :?

the control source will need to be

=test([FirstName])