Nz function???

[mission2java_78]

ok

 

[harra]

Try stopping the code at that point and printing the contents of the price field. I suspect that the code is not actually being reached in which case the IIf() solution won't work any better.

That's what I suspect as well. I have found that many of the times when a check for NULL doesn't have the results you expect ("Hey, the field is blank, why isn't it getting caught!") it is because the field really isn't NULL, it is blank (nullstring). I still think you need to output what is the contents of that field. You can even put a debug statement in there:

Debug.print chr(34) & me.txtPrice & chr(34)

I can't test this, but if I remember correctly, if it's NULL then the output in your Immediate window will be "NULL". If it is a space, then " ". If it is an empty string then, "".