Why can't it be .T. or .F.? Just curious, because your answer may lie in how the data is represented in the interface and not how it's stored. You can format the display/report to show blank for .F.
>Hi everybody,
>
>I have a problem, which seems to me have no solutions.
>
>I have a logical field, which I want to populate with .t. on some condition and leave blank otherwise.
>
>I have to create this field using IIF expression:
>LogicalFiled=IIF (somecondition,.t.,.f.)
>
>My question is: How can I make this field blank, if !somecondition?
>
>Thanks in advance
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05