>>Is there a quick way to replace all the fields in a record that have a .Null. value to a blank value of the field's type, i.e. " " for char, 0 for numbr, .F. for logical, etc.? If it is easier to do this in an array, please let me know.
>>Thanks!
>
>How about something like.......
>
>

>SCATTER TO aValues MEMO
>FOR iValue = 1 TO ALEN(aValues)
>    IF ISNULL(aValues[iValue])
>        BLANK FIELDS (FIELD(iValue))
>    ENDIF
>ENDFOR

Now I see I didn't read close enough :)

Jim only wanted to do this for a record, not for all fields in a table.