Replace #ERROR message in report (1 Viewer)

A

access2010

Registered User.

Local time

Today, 09:38

Joined

Dec 26, 2009

Messages

1,021

• Mar 8, 2018

• #1

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

 

Attachments

• No_Records_Message.mdb

  1 MB · Views: 69

W

Wayne

Crazy Canuck

Local time

Today, 12:38

Joined

Nov 4, 2012

Messages

176

• Mar 8, 2018

• #2

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

 

A

access2010

Registered User.

Local time

Today, 09:38

Joined

Dec 26, 2009

Messages

1,021

• Mar 8, 2018

• #3

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

 

Attachments

• 
  #Error.PNG

  18.1 KB · Views: 64

jdraw

Super Moderator

Staff member

Local time

Today, 12:38

Joined

Jan 23, 2006

Messages

15,379

• Mar 8, 2018

• #4

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.

 

G

Galaxiom

Super Moderator

Staff member

Local time

Tomorrow, 02:38

Joined

Jan 20, 2009

Messages

12,852

• Mar 8, 2018

• #5

Code:Copy to clipboard

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

 

A

access2010

Registered User.

Local time

Today, 09:38

Joined

Dec 26, 2009

Messages

1,021

• Mar 18, 2018

• #6

Thank you for your assistance and your suggestion works

Nicole