>
>Rob,
>
>By currency fields are (or at least seem to be) initialized to 0 when a record is inserted or appended. ISBLANK() will never return .T. for a currency field. This function was created to determine whether or not the field had a value inserted into it. EMPTY() will return .T. if a value less than 0.00004 is inserted. Insert 0.00005 and it's rounded up to 0.0001 and EMPTY() returns .F.
>
>In short, EMPTY() returns .T. if a value hasn't been inserted in a field or if the value for the data type is considered empty. For example, for a numeric, integer, or currency field 0 will return .T. For a string "" equates to empty, and so on.
>
>Does this help?
--------------
George, yes is does help....my_currency_fld is created with a SELECT and
zeros are not automatically inserted...if that was the case..I would not
have this problem I am having....empty(my_currency_fld) returns .F. even tho
thers is nothing is the fld.........but........?isnull(my_currency_fld)
returns true if my_currency_fld is empty and isnull(my_currency_fld) returns
false if their is a zero in my_currency_fld....so that is my answer...
I will check for ISNULL().....thanks all.....:))))