We help IT Professionals succeed at work.

Getting a #Name? error in reports

Cole100
Cole100 asked
on
It seems to be hit and miss that I get this #NAME? error in the same field. It does not seem to matter what the data is in that spot it still makes the error during PRINT PREVIEW or PDF EXPORT. I've also tried removing the conditional formatting and that has not made a differance, It is supposed to say BLU. I have tried changing the sort on put the GREEN on top and it still gives the same error. Like I said, some reports it is fine but others give me this. Any idea's? Screenshot of #NAME? error
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
What is in the Control Source property of that textbox?
Cole100IT Systems Manager

Author

Commented:
Control Source says "region". I created a table that groups my store numbers into colored region names. (ie store number 598 and 723 get grouped into the "blue" region) Screenshot
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
Can you post a sample database showing this with any sensitive data masked or removed?
Cole100IT Systems Manager

Author

Commented:
I am afriad I do not know how to do that
Jeffrey CoachmanMIS Liason
CERTIFIED EXPERT
Most Valuable Expert 2012

Commented:
Don't know how to post the database?
Don't know how to remove/mask sensitive data?
Both?
Something else entirely?

CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013
Commented:
There is a 'File' link underneath the box where you type your comments in this thread.  That lets you attach a file such as a sample database to your comment, just like you did with your screenshot.

Before posting a database here, however make sure that there is no sensitive data in it such as people's real names, email addresses, phone numbers, etc (use fake data if needed).
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2013

Commented:
Cole100,

Did you resolve this one independently?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.