MS Access report display #Name?

[pelagic]

Hi all,
What does it mean when Microsoft Access Report displays
#Name?. How could I fix this error? I have checked for field name, I also made the field big and long enough, but it did not solve this problem. Could anyone give me a hint.

Thanks in advance,

 

[dhookom]

There may be more than one cause of this. The popular issue is when your control source is an expression like:
=FirstName & " " & LastName
And your control name is a field name like:
FirstName

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[THWatson]

pelagic
#Name means that the control source you have supplied for the control is not valid.

So, perhaps the field does not exist in the table or query. Or the field name is misspelled.

Or, maybe you are trying to do a calculation in a control but are referencing a field as the control source. If this is the case, then make the control an unbound control.

If you want further information, take a look at this link from the Microsoft Knowledge Base.

http://office.microsoft.com/en-us/assistance/HA011814471033.aspx

Tom