Assigning a value to a text box.

[Parker]

Hi All,
I run code when a report opens. I'm using this syntax Me!textbox = a
calculated value. The textbox is unbound. I get an error saying I can't
assign a value to this object. I do this all the time with forms. Can I do
this in a report?

Thanks

 

[Roger Carlson]

Can't you just put your calculation in the Control Source of the textbox?
If not, try putting the code in a different event like Form Load.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jeff Boyce]

What happens if you run this later in the "opening" process, say, "OnFormat"
instead?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[fredg]

Hi All,
I run code when a report opens. I'm using this syntax Me!textbox = a
calculated value. The textbox is unbound. I get an error saying I can't
assign a value to this object. I do this all the time with forms. Can I do
this in a report?

Thanks

If you can't simply enter the expression in the unbound control's
control source, try the Report's Report Header Format event.

 

[Parker]

Putting it in the OnFormat process worked. Thanks to both of you for the
reply.