MSflexgrid and null values

[CSamuels]

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

[Danial]

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

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

[mdake]

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

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