I'm using the code below to fill in a combox. The field can be NULL and I get an error msg when it is. I'm using the code below, but am having a problem on the line where I'm adding string.empty
(cmbAccount.Items.Add = String.Empty)...do I have this coded right?



VB Code:
  1. Do While objDR.Read = True
  2.                     If (objDR("vendor_name")) Is DBNull.Value Then
  3.                         cmbAccount.Items.Add = String.Empty
  4.                     Else
  5.                         Me.cmbAccount.Items.Add(RTrim(objDR("vendor_name")))
  6.                     End If