How to pass a value from a Public function to a report?

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

Guest

I have a public function, that I have tested using a MsgBox. It is
calculating the correct value. How to I show this value on a report?

There are two posts from other members I have tried to apply, but I am doing
something wrong. The 1st post is dated 10/19/04 with an Answer from Diane H.
titled Passing Function to report. The 2nd is dated 7/12/05 with an answer
from Dan S. titled Global Variables.

Any help would be great!
Charles
 
Return the value with the function
e.g
Function GetValue()
GetValue="The value"
End Function
============================================
In the ControlSource Property of any field in the Report write
=GetValue() ' Your function name
============================================
 
Back
Top