Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Control Source of Text Box

Status
Not open for further replies.

SIG357

Programmer
Jun 29, 2000
164
0
0
US
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

Joe [sig][/sig]
 
did you try = GetFirstDate()


PaulF [sig][/sig]
 
Have you read through Help about the #Name error message to see if any the reasons apply? [sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top