if else including null and empty record

Posted on 2006-07-09
Last Modified: 2010-04-06

I have an if else statement which works if the record is empty but has a had a record in it before, how can I have this so it can also check for null, as in if spud = "" or null.

' Show IF Conditional region14
  If (Recmostofuser.Fields.Item("spud").Value) = "" Then

grateful for any help


Question by:thatelvis
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 52

Expert Comment

by:Carl Tawn
ID: 17068901

    If IsNull(Recmostofuser.Fileds.Item("spud").Value) Or Recmostofuser.Fields.Item("spud").Value) = "" Then
LVL 26

Accepted Solution

DireOrbAnt earned 125 total points
ID: 17069319
That might not work. If it doesn't try:
If IsDBNull(Recmostofuser.Fileds.Item("spud").Value) Or Recmostofuser.Fields.Item("spud").Value = "" Then
Or try:
If ("" & Recmostofuser.Fields.Item("spud").Value) = "" Then


Author Comment

ID: 17071473
this worked thanks all

If ("" & Recmostofuser.Fields.Item("spud").Value) = "" Then


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Auto Complete Using JQuery 5 95
Web Application Architecture 6 83
asp Google Map 2 89
migrating to phpbb forum from vBulletin 4.2 3 90
Preface In the first article: A Better Website Login System ( I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
Shoutout to Emily Plummer ( for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question