Invalid use of null error in report

  • Thread starter Thread starter sabariab
  • Start date Start date
S

sabariab

Hi to all,

It's my first time here in microsoft access forum.

I have a report which produces an error "Invalid Use of Null" althoug
the report is quite ok, all the data are there except for an erro
dialog box that says "Invalid use of null".

I check all record source of the report and they are all ok. When
click the print preview for the report, it opens up and the erro
message shows. What seems to be the problem? There's no other code i
the command button except the usual "DoCmd.Openreport .... "

Thanks.

Arne
 
sabariab said:
I have a report which produces an error "Invalid Use of Null" although
the report is quite ok, all the data are there except for an error
dialog box that says "Invalid use of null".

I check all record source of the report and they are all ok. When I
click the print preview for the report, it opens up and the error
message shows. What seems to be the problem? There's no other code in
the command button except the usual "DoCmd.Openreport .... "
Click to expand...


Try looking at the expressions in the report's text boxes to
see if you're using a function with a field as an argument.
Some functions do not accept Null and if one of your data
records doesn't have a value in that field, then you'll get
that message.

The same thing can happen in a calculated field in the
report's record source query, or in an expression in the
report's Sorting and Grouping list.
 
Back
Top