>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.
Thom,
I never tried but DynamicInputMask might work for you.
Cetin