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!

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

Setting Cotrol Source of Text Box (also under Access, sorry)

Status
Not open for further replies.
SIG357

SIG357

Programmer
Jun 29, 2000
164
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]
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
1K
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
436
hermanlaksko
hermanlaksko
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
238
linuxguyEastCoast
linuxguyEastCoast
Katto
  • Locked
  • Question
VBA permutation of arrays
2
Replies
22
Views
428
Katto
Katto
kapok1
  • Locked
  • Question
add all the files under the same folder including the subfolder, all sheets in worbook included
Replies
2
Views
133
kapok1
kapok1

Part and Inventory Search

Sponsor

Back
Top