> But if I say > vTest = Colname > I get zero regardless of whether the form is in > enter or edit mode.
I agree that there's a problem with distinguishing NULLs with ZERO set ON. I hit the same problem about a year ago (I'll be on client site next Tuesday and will try to figure out how I solved the problem -- but I don't recall it was a particularly satisfactory solution). However, if the above statement were to move the NULL value from ColName to vTest, then you would be introducing a further inconsistency -- because the expression ColName (although a very simple expression, an expression none-the-less) would not be evaluated according the logic of SET ZERO ON. It's a conundrum what to do about it. As I said, I'll try to see what I did about the issue when I dealt with it a year ago. -- Larry __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com
