>>>I think I ran into this previously, but I cant remember how it is done. I have a logical field in a grid and I want to display YES for .T. and NO for .F. It is a readonly field just for display purposes. How do you set up the field in the grid to do this (Column settings as well as textbox settings).
>>>
>>>TIA
>>
>>IIF(myLogicalField, "YES", "NO") in Column.ControlSource
>
>That worked, thanks Nick. I could have thought I tried that already, but I guess not.
Something else that I have done using this that's useful is to set the columns FontName to "Wingdings" and in the test statement:
IIF(myLogicalField, CHR(252), "")
which gives a check mark when true and blank when false.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.