To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Corel Paradox Delphi Delphi Prism Java JavaScript Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands +Database +OOP Basics +OOP Details

	VB.Net Guides
VB.Net To/From Conversion Guides VB.Net and ASP Classic VB.Net and C# VB.Net and C++ VB.Net and C++/CLI VB.Net and Corel Paradox VB.Net and Delphi VB.Net and Delphi Prism VB.Net and Java VB.Net and JavaScript VB.Net and Perl VB.Net and PHP VB.Net and VB Classic

Cross Ref Guide

VB.NETLANGUAGE

VB.Net

VB.NETANDACCESS VBATOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

Empty String Check◄╣

+Commands

+OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► VB.Net

Print This

Empty String Check (VB.Net and Access VBA Cross Reference Guide)

By Mike Prestwood

VB.Net versus Access VBA: A side by side comparison between VB.Net and Access VBA.

Operators

A language symbol used for assignment, comparison, computational, or as a logical.

Empty String Check

[Other Languages]

Languages Focus

An empty string is a zero length string, a string that is equal to null (""), or not assigned. In some languages, you can check if a string is empty by comparing it to an empty string (""). Some languages distinguish between nil and null ("") so checking if the length is 0 is easier.

VB.Net: String.IsNullOrEmpty

In .Net, a string can be null or empty. The .Net framework offers a static method in the string class: String.IsNullOrEmpty to check if a string is null or empty.

Syntax Example: 1 certification question.

Dim s As String

's = "" 'Uncomment to test 2nd case.

If String.IsNullOrEmpty(s) Then
  MessageBox.Show("hello")
End If

Access VBA: Len(s&vbNullString)

In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Syntax Example:

All these will work for variables unassigned, set to "", or set to Null:

If s&"" = "" Then
  MsgBox ("Quotes with &'' say null is empty")
End If

 
If Len(s&"") = 0 Then
  MsgBox ("Len with &'' says null is empty")
End If

If Len(s&vbNullString) = 0 Then
  MsgBox ("Using vbNullString also works!")
End If