How do you set a numeric field to NULL?
Jim
>>I tried removing the column controlsources. Everything was ok. I am using a cursor as the recorsource. What I do is collect my records into the cursor THEN assign the recordsource. If I reselect into the cursor I remove the recordsource 1st. Then reset it after I have gotten the new records. If you just leave the recordsource you will have the problem. I just tested this.
>
>The fix for a set table or view I have found for this little problem is to use NULLS for 0 values. Then
>
>SET NULLDISPLAY TO ' '
>
>and even when cell has focus it's blank.
Thanks
Jim