I'm trying to set the text in text box using the Control Source Property. The text box is a header in a report, and I need this header to change depending on the date. The function I want to use to return the text of the header is in a Standard Module called RFunctions. The problem is, when I try to set the Control Source to say, RFunctions.GetFirstDate(), it gives me a syntax error. If I just put the name of the function in Control Source say, GetFirstDate(), I get one of those damn #Na things on my report. Any clue what I'm doing wrong? Thanks in advance
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.