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
Printable View
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.
Hope this helpCode:
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")
You can try it this, by just appending an empty string to the field data...
flxContact.textmatrix(1,1) = rsOrg("Url") & ""