Full Version: How to call the public variable value in Report
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
Dear All,

I would like to use the value of a variable defined in the module in a report. I created a text box and assigned the control source property to "=[sCurrency]" where sCurrency is the variable defined in the module. This is not recognized and asking for the parameter value for "sCurrency" while running the report, but when I use the same variable in forms it shows the value stored in the variable "sCurrency".

This is very much required as I need to print the currency type in the reports using the public variable.

Could any one give any suggestion for this ?

Thanks in advance.


You must write a function that will return the value. Something like this

Public Function GetCurrency() As String
GetCurrency = sCurrency
End Function

Then use the function name in the control source property

Bo Melin
Hi Murali,

Use a function to return the value of your global variable:

Public Function fCurrency() As String

    fCurrency = sCurrency

End Function

Make the function return the same datatype as sCurrency (I'm guessing it's a string since it's called 's'Currency)


Dear Bo Melin & CheekyBuddha,

Thank you so much, it works. I really appreciate the great support provided by both of you.


This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.