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
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.