Can I Cancel Report if Error on Format Event?

[Nancy26]

I have a report with a Format Event on the detail section. Is it possible to cancel the report if the Format Event raises an Error?

I have been able to display a msgbox - but unable to cancel the report.

Thanks,
Nancy

 

[D B Lawson]

After the msg box in the code have you tried

Cancel = True

 

[Nancy26]

Cancel = true does not cancel the report