#Error in txt box when concatenating a different txt box

  • Thread starter Thread starter Bill R via AccessMonster.com
  • Start date Start date
B

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
 
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.
 
Back
Top