UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Setting a report text box to a string value on open, Office 2003    
 
   
teabags
post Aug 4 2010, 08:07 PM
Post #1

UtterAccess Veteran
Posts: 419
From: Ireland
Hello,

I want to set a textbox txtHorizon to be equal to a string strHorizon on report open.

But I can't do this in vba like so?

Private Sub Report_Open(Cancel As Integer)
[txtHorizon] = strHorizon
End Sub

Why is this?

Thank you.
Go to the top of the page
 
+
kerih
post Aug 4 2010, 09:02 PM
Post #2

UtterAccess Member
Posts: 27
From: San Diego, CA
Use the format event of the section with the textbox control. Use syntax as below.

Me!txtHorizon.Value = strHorizon
Go to the top of the page
 
+
teabags
post Aug 5 2010, 12:32 PM
Post #3

UtterAccess Veteran
Posts: 419
From: Ireland
QUOTE (kerih @ Aug 5 2010, 03:02 AM) *
Use the format event of the section with the textbox control. Use syntax as below.

Me!txtHorizon.Value = strHorizon

Thank you.
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:37 PM