>hmmm.. I should be able to set the grids column's textbox controlsource to say:
>
>(IIF(reversals.certrequired = .Null.,"" ,reversals.certrequired))
>so if the certrequired columm is null it displays "", otherwise the value? But the grid is still displaying null.
>
>Am I crazy?
No, but you tried to compare with null, the result of which is always null, which behaves as .f. in an if/iif. Try
?iif(1=null, "is null", "is not")
and see what you get. You should use iif(isnull(something), "", something) if you really want, but why bother with the controlsource? Just
set nulldisplay to ""
and you'll have what you wanted.