Text Box results in error

[RBear3]

I downloaded the "Issues" database template and modified it pretty heavily.
One of the fields is a lookup type of field. In a canned report, this field
displays fine when I place it in my detail section or my section header. If
I try to use it in an unbound text box, I get an error.

If I enter =[Application] or = "Appl: " & [Application]

I get #Error

Can anyone tell me why it works as a bound field, but not in a text box?

 

[Allen Browne]

Did you change the Name property of the text box as well?

Access gets confused if the control has the same Name as a field, but is
bound to something else.

In any case, Application is a reserved word in Access, so a poor choice of
name for a field. I understand you probably didn't choose this name, but
that doesn't change the fact that is can cause problems. For a list of names
to avoid (more than 1000 of them), see:
http://allenbrowne.com/AppIssueBadWord.html