Jim Lawrence (AccessD)
accessd at shaw.ca
Tue Jun 8 10:05:41 CDT 2004
Hi Martin: I am not sure this will work in this particular circumstances but the error happens because there is a 'null' value. Maybe something like: MyReport.MyField.Value = MyDataField.Value & "" HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Caro Sent: Tuesday, June 08, 2004 3: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