To all,

I've got a grid that's displaying highly reduced data. I've got it to the point that it looks almost exactly like its corresponding hard-copy report, including blank space (empty rows). To get this effect I had to format the columns with:

MyGrid.Column1.FORMAT = 'Z 99,999,999,999'

My users have come back and said they want to see zeros where there are zero values. If I remove the 'Z' format code, they'll get zeros everywhere.

The cursor driving the grid has two fields HeaderRow and HiLiteRow, which are logicals that are used to drive the DynmaicBackColor of the columns. I want to use these fields to dynamically format the cells; If its a HeaderRow or HiLiteRow, suppress zeros, otherwise show zeros.

I tried:
MyGrid.Column1.FORMAT = "IIF(PdaGrid.HeaderRow .OR. PdaGrid.HiLiteRow, 'Z 999', '99,999,999,999')"

with disasterous results.

Any suggestions?

TIA

Thom C.