Access97: Unknown Error

  • Thread starter Thread starter Jonathan Scott via AccessMonster.com
  • Start date Start date
J

Jonathan Scott via AccessMonster.com

In a report, I am getting "#Error" in one of my fields, and I can find no
way to make it tell me what the error is. What can I do to make Access97
tell me what exactly it is having a problem with?

Jonathan Scott
 
There are a number of reasons that you might see this. Perhaps you should
provide use with some information about the report, its records source, and
the control source of the text box.
 
Here is the query:

=IIf(IsNull([newOfficeCode]) Or IsEmpty([newOfficeCode]),[officeCode],
[newOfficeCode])

When newOfficeCode is not null, I get the newOfficeCode, as expected. When
it is null/empty, I get "#Error". Both officeCode and newOfficeCode exist
in my table and in the query I use as the record source for the report.
This is inside textbox, and officeCode and newOfficeCode are of the same
data type.

Lastly, in the original version, only officeCode was used, and it had no
problem. I now want to make this report display newOfficeCode in the event
there is in fact one to display. Just can't figure what gives.

Jonathan Scott
 
Try either:
=Nz([newOfficeCode],[officeCode])
or
=IIf(Len([newOfficeCode] & "")=0,[officeCode], [newOfficeCode])
 
Doesn't work. I was hoping there was a way to make Access give meaningful
information. Is there no hope that I can debug it on my own without
resorting to trying every single possible permutation just to find out what
the problem is?

Jonathan Scott
 
Back
Top