Calling a function (1 Viewer)

[Leigh]

I am building a form using Access 97. Several fields call functions from the same module to generate the data, One function is not running at all -- sometimes. I can tell that all other functions are running as they should always. I can tell the field in question is always receiving focus, I can tell that the function runs most of the time (scrolling through records), but it does not get called on some records. I don't see any pattern. I tried using a simple MsgBox as the first line inside the function to see if it executes; it does not execute on some records.

Any ideas or suggestions??

Thanks!
Leigh

 

[R. Hicks]

If the function is doing calculations it may be encountering some null values. If this is the case and your function recieves a null this may be the problem. You may have to convert the nulls to zeros using the Nz function to fix the problem.

HTH
RDH