#Name?

[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.

 

[TC]

IsNull without a parameter does not make any sense. The IsNull() function
requires a parameter.

HTH,
TC

 

[Guest]

An example of the line would be
=IIf(IsNull([home]),"",[home])
thanks,
Cathy

 

[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





.