Our office is having a very strange issue with Access 2007.
Long story short - over the past few weeks, half the computers were upgraded to Windows 10, and all of them were upgraded to Office 2013 - except for Access, which we kept at 2007 to keep legacy databases working a little while longer.
All the computers in the office are working perfectly fine under this setup.
Two of them, however, are not displaying some of the Access reports properly. Fields that are not directly linked to a table field and generated on the fly (for example, ControlSource property of the text field something like '=[ThisField] + " and " + [ThatField]') do not show up, and instead display "#Name?" as if it can't connect to the data. However, on the exact same report, there will be fields with the control source directly linked to a field (for example, "MyField" in the query in the report's record source) that will work just fine!
Only two computers in our office are having this problem; the rest display all fields as expected.
Does anyone have any idea why this would be happening? Is it some weird side effect of having Office 2013 and Access 2007 side by side? We do not have Access 2013 installed. It might be worth mentioning that these two computers were purchased around the same time; however, so were two others that are working fine, one of which is on Windows 10 and the other on 7.
Any thoughts or suggestions would be appreciated. Thanks!