#Error in txt box when concatenating a different txt box

[Bill R via AccessMonster.com]

This is wierd. I have a text box that displays perfectly. It's control source
reads:

="Total in " & [Status Word] & ": " & Count([DWG_NO])

and returns something like "Total in DCA: 6". When I put a text box in the
group header with a control source of:

=[Status Word] & ": "

both text boxes display #Error. Any ideas?

Thanks,

Bill

 

[Allen Browne]

Try changing the Name of this text box.

One cause of #Error is if the text box has the same name as a field, but is
bound to something else.