[AccessD] Report #Error

I'm building a report and have a text box that references a box within a sub report. It works fine except when the sub report returns no data so I get #Error in the first box. I have tried to capture this event in the No_Data and on_error events of the main and sub reports but no luck. 

Any ideas where to capture this event so I can seed the referencing box with zero.

Martin