#Name?

  • Thread starter Thread starter cathy
  • Start date Start date
C

cathy

I have copied a report to a new name to change the size
paper it prints on but as soon as I change the Page Setup
when I view or try to print the report I get a #Name? in
the lines that have the equation =IsNull(). The original
report works fine. I can view the report correctly the
first time but if i make one more change or exit the
database I get the #Name? error. I've tried cut and paste
of the text boxes with no luck. I'm the network
supervisor so it isn't a valid security issue but this
occured right after an XP online update.
Thanks for any help.
 
IsNull without a parameter does not make any sense. The IsNull() function
requires a parameter.

HTH,
TC
 
Or equivalently:

= Nz([home], "")

TC :-)


An example of the line would be
=IIf(IsNull([home]),"",[home])
thanks,
Cathy
-----Original Message-----
IsNull without a parameter does not make any sense. The IsNull() function
requires a parameter.

HTH,
TC





.
Click to expand...
Click to expand...
 
Back
Top