I have a report with an unbound text field on it and I'm just trying to pass a string to it like this:

me.myfield.value = "myText"

When I try to do this I get the 'You can't assign a value to this object' error. I'm using access 2007.

Anyone have any ideas?

If I recall this situation correctly, in the event that you have
this code in the Report_Open() event, you may want to try moving
it into the Report_Activate() event.

Do you have it in an event other that Report_Open()?

Where is the textbox on your report? I've had a similar problem before and I had the textbox under the page footer instead of the report footer. It makes all the difference in the world.

Also, try this with text boxes:

me.myfield = "myText"

.Value is not needed when posting to a text box, only when retrieving values, sometimes.



mmcdonal

Look it up at: http://wrox.books24x7.com

Welcome to P2P.

Another situation is that the textbox is unbound with a value ALREADY set in its control source. If you try to set a value to it via VBA code as well, you will get that error.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division