>I have a query that returns its results (cursor) as a GRID in a second form. The first GRID field contains a .T. flag if a resource is checked-out of my VideoTape library, otherwise I simply want the field to remain blank. It is currently being filled with .NULL. if the resource is NOT checked.
>
>Is it possible to suppress the display of the .NULL. value in this grid column ??
>
>Thanks.
Might be easier to modify your query:
Select nvl(CheckedOut, .F.) as CheckedOut...
In the InputMask of the column, put the letter Y. This will display the status as either a Y or N. Change Sparse to .F. If you just have to have the NO be represented by a blank:
Select iif(nvl(CheckedOut, .F.), "Y", " ") as CheckedOut...
Mark McCasland
Midlothian, TX USA