I am getting #NAME? in a report in Access. This field is only formatting another field in the group header. The field that is giving me #NAME? has this for a control source ="Week " & Format$([ScheduledDate],"w
The ScheduledDate field shows up fine on the report. When I first created the report, all fields showed without any problem. After about two weeks I started to see #NAME? on the "format by week" field in the group header. But if I created a new text box right next to the field and copied the control source from the problem field into the new text box, then both fields worked properly. I can delete either the new field or the old "problem" field and the remaining field works fine. But once I save the report and close Access and re-open it again, then I have the same problem all over again.
I have read about a similar issue if there are similar names, but I do not see any similarities, the field name is text50
Below are screen shots.