Larry, The real nasty here is the inconsistency.
With ZERO ON, if I say SELECT Colname into vTest FROM TableName where Colname is null and limit = 1 I retrieve a NULL If, in the form, I say vTest = Colname IN TableName where Colname is null and limit = 1 I will also retrieve NULL But if I say vTest = Colname I get zero regardless of whether the form is in enter or edit mode. That is what needs to be fixed if anything is going to work. I wonder if I have an ice cube's chance in boiling water to see this fixed. then in the eep i could use: if vTest is null then -- whatever if null else -- whatever if not null endif Thanks Dennis McGrath
