So, the way I proposed about fore color should work (hiding of textbox content by setting foreground color the same as background). NULL is not good idea for goo UI, I suggest. However, you may try this in SQL select:

SELECT ..., iif(MyField=0,.NULL.,MyField)+0000.00 as MyField, ...

'+0000.00' required to correctly pre-format field in result for case when first row contains 0.


>I create the cursor in the load of a form before the grid is created and before the control sources for the columns are set. I do not reselect into the cursor. Isn't this the same thing you are doing?
>
>>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.
>>
>>HTH
>>Mike