reports access 97

[Jim]

I have a database on access 97. When i run reports most
of them are fine but on 2 of them i get the following
error > Runtime error 94 'Invalid use of null. Any idea
where to fix the problem ?

 

[Allen Browne]

Jim, there are so many possible causes for this error!

If the report is based on a query, open the query directly, and see if any
columns contain #Error.

When you see the error message, what is the Title of the dialog?
Does it display any code?

If the report uses any code or functions, see:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html
The article explains 6 cases where you may run into errors with Null.

A common cause is an attempt to assign something that has a Null value (such
as a text box) to a string or numeric or date variable in VBA. The Variant
is the only VBA data type that can be Null.