>>>>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
That is a good tip.. Thanks I will save that one as a keeper...
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope