reports access 97

  • Thread starter Thread starter Jim
  • Start date Start date
J

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 ?
 
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.
 
Back
Top