MSflexgrid and null values

I am pull information into a flexgrid through a SQL statement. How do I allow it to accept a null value from the table

I tried

Msflexgrid.allowzerolength = true but allowzerolength isn't a property of the msflexgrid can someone please help


Crystal

Hi,
I usaually use a function to format the data before displaying
it on the flexgrid.

Code:

---


Function FormatNull(NullData) As String
    If IsNull(NullData) Then
        FormatNull = ""
    Else
        FormatNull = NullData
    End If
   
End Function

'usage:
flxContact.textmatrix(1,1)=FormatNull(rsOrg("Url")

---

Hope this help

You can try it this, by just appending an empty string to the field data...

flxContact.textmatrix(1,1) = rsOrg("Url") & ""