Access 2010 - Report field returns error: #Size!

[brharrii]

I'm using the following code as the control source for a control on a report to display the weight and weight unit together.

=IIf(Nz([RetailCaseWeight],"")="","",[RetailCaseWeight] & [RetailCaseWeightUnits])

When I run the report the object displays the following message: #Size!



While in design view the object has a green flag in the corner that when highlighted tells me that it is an

"Invalid control Property: Control Source"
"circular Reference"


Does anyone have any idea what my problem might be?

Thanks!

[pbaldy]

Based on the error, I'd guess the textbox has the same name as one of the fields.

[brharrii]

ah, so it does. I didn't realize that was a no no.

I've corrected that and the green flag is no longer there. I still have the #Size! Error when I run the report though.

[brharrii]

ah nevermind, that fixed it. When I changed the text box name it had changed the name of my control as well. Thanks again

[pbaldy]

No problem. That's a bit of a pet peeve of mine. The wizards and such will name the textbox the same as the field, then if you do something like you did, it barfs. Seems like it would be simple for it to add a default prefix to the control names when they're created.