Check for empty field

Results 1 to 2 of 2

Thread: Check for empty field

  1. #1
    Join Date
    Dec 1969

    Default Check for empty field

    I&#039;m trying to check to see if a field in a recordset is empty. If it is I would like to print something. Here is what I have, but it isn&#039;t working. It is a text field I&#039;m checking.<BR><BR>&#060;%<BR>if RS.Fields("projectNumber")="" then<BR> response.write("General Charges")<BR>end if<BR>%&#062;<BR><BR>that isn&#039;t working at all. I&#039;ve tried a few variations. Is there something that I&#039;m missing or a quick fix? Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Check for empty field

    try <BR>if trim(RS.Fields("projectnumber"))= "" or isnull(rs.fields("ProjectNumber")) then<BR> ......<BR><BR>end if <BR><BR>mj

Posting Permissions

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