Replace #ERROR message in report (1 Viewer)

[access2010]

When using our Access 2003 database we would like to make a change to our reports.
Could you please assist us in changing the word [ #ERROR ] message to [ NO Transaction ] or no record

We would like to do this, when using our form C_Audit_FR

Thank you for your assistance.
Nicole

 

[Wayne]

I looked at your database. I tried a few scenarios, but didn't get any #ERROR messages. Where does it occur?

 

[access2010]

Hello and thank you for your note.

The Volenteer staff in our office keep getting confused when they see the word [ #ERROR ] in our reports.

Can you please advise me how to change the word [ #ERROR ] when there is no data to the report to [ NO Transaction ]

Thank you,
Marilyn

 

[jdraw]

I can't open the mdb (using 2016) but it looks like you might have null values in your calculation. It doesn't seem to be a Error with a message as such.

See this article by Allen Browne

also this might be useful.

 

[Galaxiom]

IIF(IsError([whatever]),"No Transactions",[whatever])

 

[access2010]

Thank you for your assistance and your suggestion works

Nicole