>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?

Yes, not to use NVL.... ;-)