Null Fields

Results 1 to 4 of 4

Thread: Null Fields

  1. #1
    jeob Guest

    Default Null Fields

    What code do I use to check and see if a field in a recordset is empty.<BR>I&#039ve tried :<BR>If rst("Field") = Empty Then<BR>&<BR>If Is Null(rst("Field") Then<BR>but none work.<BR>Any help greatly appreciated.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Null Fields

    Try:<BR><BR>If IsEmpty(rst("field"))

  3. #3
    J Smyth Guest

    Default RE: Null Fields

    if IsNull(rst("Field")) then<BR><BR>Isnull no space and you missed a bracket but the DB may hold it as an empty string so try: <BR>if (IsNull(rst("Field"))) or (rst("Field")="") then

  4. #4
    jeob Guest

    Default Problem Occurred

    ADODB.Fields error &#039 800a0cc1&#039 <BR>ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application. <BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts