Null Values On Report

  • Thread starter Thread starter David Tunstall
  • Start date Start date
D

David Tunstall

Please help.

I am trying to show zero for null values but am not
having much luck - I've tried the Nz function but can't
get it to work.

I have this code from the Access Web: Handling Null Values

http://www.mvps.org/access/reports/index.html
but I am unsure of where it should go:
(On Form open, Form Load.......)


Function ErrorAvoid(n As Variant) As Variant
On Error GoTo Trap
ErrorAvoid = n
Exit Function
Trap:
ErrorAvoid = 0
Resume Next
Exit Function
End Function


Hope this makes sense
Thanks
David
 
Answered in the previous thread.

Are you sure you actually have a Null value and not an empty string?
 
Back
Top