Null Function in Visual Basic????
Posted on 2006-05-28
I am exporting some data from a table into a fixed width file. The problem i have is that lots of the values are Null. I was getting around this by doing the following:
If IsNull(objGRNList("UNIT_QTY")) = True Then
strGRNListQty = ""
strGRNListQty = objGRNList("UNIT_QTY")
This works, but the problem is that i've got over 20 fields to do this for. I started looking at writing a function, but VB won't let me pass a null value to a function, so i'm struggling
Any ideas please?