>Thanks, but it didn't work.
> Here is the results of some of my testing.
>
>goto 2 this is 0.0
>?isnull(hcl) shows false (right to me)
>goto 3 This is a blank
>?isnull(hcl) shows false (wrong to me)
>go bott This is a newly appended blank record with only Sampl# & date
>?isnull(hcl) shows false (wrong to me)
>goto 2 thi is 0.0
>? empty(hcl) shows true (wrong to me)
>goto 3 this is blank
>? empty(hcl) shows true (right to me)
>go bott this is a new blank record
>? empty(hcl) shows true (right to me)
>
>The hcl field is Numeric 4,1 decimal I had the NULL box checked, origianlly I didn't but the results were the same.
>
>Any more ideas would be really appreciated.
Hi Gary,
ISBLANK() will return .T. if a numeric field has no value (either newly appended record or cleared with BLANK).
George
Ubi caritas et amor, deus ibi est