How I handle .NULL. displays

[jrumbaug]

Just a quick tip for fellow newbies. Working with grids and remote views, I've been struggling with displaying .NULL. values. Today I had a .NULL. date value in a grid that I could not get to go away no matter what I typed into the NULLDISPLAY property. I found a Microsoft tip that said you can set the dynamic color to white on white or blabk on black with:

 IIF(ISNULL(MyField),RGB(255,255,255),RGB(0,0,0))

But what I just learned today is my favorite.

SET NULLDISPLAY TO "NONE"

Now the word NONE appears instead of the word .NULL. No more going field to field typing in .NULL. handling info. For my application, this will do the job just fine. I hope this helps someone.

Jim Rumbaugh

 

[bborissov]

Check also NullDisplay property of TextBox, ComboBox, EditBox, ListBox, Spinner in HELP



Borislav Borissov

 

[alvechurchdata]

There's also the NVL() function.

If x holds a value then NVL(x, y) will return that value. If x is null then it will return y.

NVL(x, y) is shorthand for IIF(ISNULL(x), y, x)

Geoff Franklin

http://www.alvechurchdata.co.uk