No data returns #error

[vangundy]

When I run my report if there is no data, the text box returns #Error. If there is no data is there a way to display 0 intsead?

 

[cghoga]

In the report's On No Data event set the value of the object to 0.

Hope this helps.

 

[vangundy]

The only option I have is to choose a macro or report... is there any code invloved?

 

[ZmrAbdulla]

Close report automatically if no data found

Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me

 

[THWatson]

You can also put code in the NoData event for the report.

Tom

 

[dhookom]

If you want to display the report but don't want #Error to display in calculated text boxes, use an expression like:

=IIf([HasData], Sum([YourField]),0)

This assumes the control source of your text box currently is:
=Sum([YourField])


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]