Thanks, Fellas! I think both ways would work, but I went with Cajun's method because in the real-world case, I have to concatenate another variable and some other odds & sods. Otherwise, I do think the label method would be the way to go. Thanks again to both of you.
I have the following variable defined in a module:
Public MyVar as String
On my form, MyVar is set to either "dog" or "cat".
On the report header, I want the value of PublicVar to appear in a text box. So I set the control source of the text box to:
=[PublicVar]
right...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.