Jim,
TextBox.Format='Z' and Column.Sparse=.F. worked for non-selected cells only. Selected cells shows the zero in reverse color though.
Column.Format='Z', and TextBox.Format='Z' with Coumn.Sparse=.T. also produced the same results.
I remembered we needed something that totally didn't show zero for the OrderRouting proj. So we added a secondary TextBox, Disabled or ReadOnly, no ControlSource, and set the DynamicCC based on the values. However, the Dynamics really slowed down the refresh.
Also, I had this problem with the MousePointer property in the Grid. I tried to get the MP to show Arrow instead of the default I-beam for TextBoxes. Tried all sorts of settings, includinf setting the Forms' MP, MouseIcon property, and using EditBoxes with Memo fields in place of the TextBoxes, but we couldn't get the non-selected cells to show the Arrow instead of the default I-beam.
Perhaps there's another way. Anyone?
Kenneth
Kenneth.