#Name? - Access 2007-Windows 7

[rick allison]

Anyone have an idea?

Access 2007, Windows 7 - a report shows #Name?
Access 2007, Windows XP - report shows the values
The code is identical on both computers.

#Name? is showing for a for a text box - Here's what's in the text box
=[breedname] & ". " & Right([Title],Len([title])-15) & " " &
Right([sexorder],Len([sexorder])-2)

I for the life of me I cannot understand why?

Do you know?

Rick

 

[Gina Whipp]

Rick,

Two things...

1. Check your References under Tools in any VBA module
2. Make sure your database is in a Trusted Location

http://www.regina-whipp.com/index_files/TrustedLocation.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Anyone have an idea?

Access 2007, Windows 7 - a report shows #Name?
Access 2007, Windows XP - report shows the values
The code is identical on both computers.

#Name? is showing for a for a text box - Here's what's in the text box
=[breedname] & ". " & Right([Title],Len([title])-15) & " " &
Right([sexorder],Len([sexorder])-2)

I for the life of me I cannot understand why?

Do you know?

Rick