[AccessD] Report #Error

Martin
I have always use
IIF(IsError([YourSubformReference],0,[YourSubformReference])
Using the IsError function to trap for the error, and the Immediate If to
display the Zero.

Mike 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Caro
Sent: Tuesday, June 08, 2004 6:55 AM
To: Access Developers discussion and problem solving
Subject: [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


--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com